Axborot texnologiyalari servisi

CREATE VIEW Z_INPUT AS (

SELECT Z.*, T.ITOVAR_SON AS INPUT_SON,

T.ITOVAR_BAXO AS OLINGAN_BAXO,

T.ITOVAR_BAXO_1 AS DONALAB_SOTISH_BAXO,

T.ITOVAR_BAXO_2 AS KUTARA_SOTISH_BAXO,

T.ITOVAR_DATA AS KELGAN_SANA,

P.PULTURI_NAME AS PUL_TURI,

TA.TAMINOT_NAME AS TAMINOTCHI, S.SOTUVCH_FIO AS OLGAN_SOTUVCHI FROM Z_TOVAR_NAME Z

INNER JOIN TOVAR_IN T ON Z.TOVAR_ID=T.TOVAR_ID INNER JOIN PULTURI P ON P.PULTURI_ID=T.PULTURI_ID INNER JOIN TAMINOT TA ON TA.TAMINOT_ID=T.TAMINOT_ID INNER JOIN SOTUVCHI S ON S.SOTUVCHI_ID=T.SOTUVCH_ID)

Mazkur tasavvur natijasi t1 nomli jadvalda keltirilgan.

Umumiy holda savdo majmuasiga kirgan maxsulotlarni soni, olingan narxi

va sotish rejalashtirilgan narxlarining jamlanmasi

SELECT TOVAR_ID, TOVAR_NAME, EDIN_NAME, SUM(INPUT_SON) AS JAMI_KELGAN,

SUM(INPUT_SON*OLINGAN_BAXO) AS JAMI_OLINGAN_BAXO,

SUM(INPUT_SON*DONALAB_SOTISH_BAXO) AS REJA_DONALAB_SOTISH,

SUM(INPUT_SON*KUTARA_SOTISH_BAXO) AS REJA_KUTARA_SOTISH

FROM Z_INPUT

GROUP BY TOVAR_ID, TOVAR_NAME

	TOVAR						TOVAR_NAME					EDIN_						JAMI_																REJA_
		_ID										NAME
																	KELGAN				OLINGAN_										DONALAB_									KUTARA_
																						BAXO											SOTISH									SOTISH
	1					Картошка						Кг		60						70000									82000									78000
	2					Памидор						Кг		50						68000									85000									80000
	3					Пиёз						Кг		60						190000									220000									196000
	4					Карам						Кг		70						175000									189000									182000
	5					Сабзи						Кг		100						100000									140000									130000
	6					Олма						Кг		20						100000									120000									110000
	7					Узум						Кг		50						175000									225000									200000
	8					Нок						Кг		30						195000									255000									225000
	11					Ананас						Кг		10						260000									300000									280000
	12					Банан						Д		60						975000									1200000									1105000
	13					Киви						Кг		25						855000									1075000									1000000
	16					Мол гўшти						Д		60						2100000									2490000									2460000
	17					Кўй гўшти						Д		30						940000									1050000									1040000
	18					Товук гўшти						Д		40						1020000									1200000									1140000
	19					Окорачка						Д		65						970000									1180000									1150000
	20					Дудланган гўшт						Д		40						1860000									1970000									1950000
	21					Колбаса (1)						Д		40						1335000									1400000									1375000
	25					Буханка						Д		250						265000									300000									287500
	26					Чўрак						Д		80						120000									136000									136000
	27					Патир						Д		60						120000									132000									132000