O’zbekiston respublikasi axborot texnologiyalari va kommunikatsiyalarini rivojlantirish vazirligi muhammad al-xorazmiy nomidagi toshkennt axborot texologiyalari universiteti ma’lumotlar bazasi fanidan amaliy ish mavzu: and, or

O’ZBEKISTON RESPUBLIKASI AXBOROT TEXNOLOGIYALARI VA KOMMUNIKATSIYALARINI RIVOJLANTIRISH VAZIRLIGI MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENNT AXBOROT TEXOLOGIYALARI UNIVERSITETI
Ma’lumotlar bazasi fanidan
AMALIY ISH

Mavzu: AND, OR, NOT mantiqiy standart so‘zlardan foydalanish.
Ma’lumotlarni saralash. Where standart so‘zidan foydalanish.

Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish.

Bajardi: Sobirjonov Shaxzod

5-labaratoriya ishi.
Ishni bajarish tartibi
So`rov: SELECT *FROM hokimyat;

1. 
   Oyligi 8 000 000 dan ko’p yoki id 2 dan katta xodimlar Id sini, FIO ini lavozimini esa katta harflarda chiqaramiz;
   

So`rov: select id, fio, UPPER(lavozimi) FROM hokimyat WHERE oyligi>8000000;

So`rov: SELECT fio, length(lavozimi), oyligi FROM hokimyat WHERE NOT id=1;


So`rov: SELECT xodim_id, Lower(FISH), manzili, length(manzili), oyligi
FROM zavod_xodimlari WHERE xodim_id BETWEEN 3 and 4;

6-labaratoriya ishi.

Ishni bajarish tartibi
So`rov: Select min(id) as ‘eng birinchi turgan qurilma’, qurilma_nomi from qurilma;

So`rov: Select max(id) as 'oxirda turgan ishchi' ,fio from hokimyat;

So`rov: Select *from hokimyat where id between 2 and 4;
So`rov: Select count(*) as ‘mashinasi’ from hokimyat;
So`rov: select avg(yoshi) as 'orta arfimetigi' from hokimyat;

So`rov: select * from hokimyat where fio='hayitov behruz';

So`rov:select sum(oyligi) as 'maoshlarining yigindisi' from hokimyat;


So`rov: select mid(mashinasi,1,1) as 'bosh harflari',mashinasi from hokimyat;

7 - LABORATORIYA ISHI

Mavzu: Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish

Sorov: select id, sum(oyligi) as 'bankdan keladigan jami summa' from hokimyat group by id;


Sorov: select*from hokimyat order by id desc;

Sorov: select * from hokimyat order by fio desc;

Sorov: select * from hokimyat order by fio asc;

8 - LABORATORIYA ISHI

Mavzu: Having standart so‘zi orqali so‘rovlar yaratish
Sorov: select * from hokimyat having oyligi >=11000000;

Sorov: select id as 'maoshi bir xil bolgan ishchilar',count(oyligi) as 'natija' from hokimyat group by id having count(oyligi)>=1;

Group by va Having kalit so’zlarining qo’llanilishi