"Xodim" jadvalini yarating va maoshi 2 300 000 dan baland bo„lgan xodimlar ro„yxatini chiqaring

3.	“Xodim” jadvalini yarating va maoshi 2 300 000 dan baland bo„lgan xodimlar ro„yxatini chiqaring.
4.	“mahsulot1” va “mahsulot2” jadvalini yarating, ularni INTERSECT komandasi yordamida kesishtiring.
6.	Nafaqaxo„r jadvalida trigger yordamida o„zgartirish amalini bajarining. Hodisada so„rov bajarilishidan

3. “Xodim” jadvalini yarating va maoshi 2 300 000 dan baland bo„lgan xodimlar ro„yxatini chiqaring.

INSERT INTO `xodim`(`ID`, `FIO`, `YOSHI`, `MAOSHI`) VALUES (1,'XUDOYBERGANOV',52,'5 600 000');

INSERT INTO `xodim`(`ID`, `FIO`, `YOSHI`, `MAOSHI`) VALUES (2,'LAPASOV',32,'8 400 000');

INSERT INTO `xodim`(`ID`, `FIO`, `YOSHI`, `MAOSHI`) VALUES (3,'AMANDAVLATOV',45,'9 300 000');

INSERT INTO `xodim`(`ID`, `FIO`, `YOSHI`, `MAOSHI`) VALUES (4,'IBRAGIMOV',33,'5 400 000');

SELECT * FROM `xodim` WHERE `MAOSHI`>'2300000'

4.	“mahsulot1” va “mahsulot2” jadvalini yarating, ularni INTERSECT komandasi yordamida kesishtiring.

INSERT INTO `maxsulot`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (1,'Gosht',2,'3 kun');

INSERT INTO `maxsulot`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (2,'Kartoshka',5,'15 kun');

INSERT INTO `maxsulot`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (3,'Piyoz',10,'17 kun');

INSERT INTO `maxsulot`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (4,'Sabzi',3,'10 kun');

INSERT INTO `maxsulot2`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (1,'Karam',5,'16');

INSERT INTO `maxsulot2`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (2,'Bodring',3,'5');

INSERT INTO `maxsulot2`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (3,'Pomidor',10,'6');

INSERT INTO `maxsulot2`(`ID`, `Nomi`, `Hajmi`, `Saqlash_muddati`) VALUES (4,'Baqlajon',2,'7');

SELECT * FROM `maxsulot` INTERSECT SELECT * FROM maxsulot2

6. Nafaqaxo„r jadvalida trigger yordamida o„zgartirish amalini bajarining. Hodisada so„rov bajarilishidan

INSERT INTO `nafaqaxor`(`ID`, `FIO`, `YOSHI`, `NAFAQASI`) VALUES (1,'Teshaboyev',65,'2 500 000');

INSERT INTO `nafaqaxor`(`ID`, `FIO`, `YOSHI`, `NAFAQASI`) VALUES (2,'Norqulov',75,'3 100 000');

INSERT INTO `nafaqaxor`(`ID`, `FIO`, `YOSHI`, `NAFAQASI`) VALUES (3,'Esonov',56,'2 900 000');

INSERT INTO `nafaqaxor`(`ID`, `FIO`, `YOSHI`, `NAFAQASI`) VALUES (4,'Tursinov',81,'1 200 000');

DELIMITER //

CREATE TRIGGER nafaqa

BEFORE UPDATE ON nafaqaxor

FOR EACH ROW

BEGIN

INSERT INTO nafaqaxor0 VALUES(`ID`, `FIO`, `YOSHI`, `NAFAQASI`);

END;//

SHOW TRIGGERS