2-amaliy ish mavzu: group by, order by, having, union, intersect, minus so’zlaridan foydalanib so’rov yaratish. Join yordamida jadvallarni birlashtirish. Standart va agregat funksiyalar asosida so’rovlar yaratish

2-AMALIY ISH
Mavzu: GROUP BY, ORDER BY, HAVING, UNION, INTERSECT, MINUS so’zlaridan foydalanib so’rov yaratish. JOIN yordamida jadvallarni birlashtirish. Standart va agregat funksiyalar asosida so’rovlar yaratish.

1. Order by, Group by, HAVING standart so’zlaridan foydalanib so’rov yaratish.

2. UNION, INTERSECT va MINUS standart buyruqlardan foydalanish.
3. Bir nechta jadvallar birlashtirish, «Join» lar bilan ishlash.
4. LOWER, UPPER, RPAD, REPLACE, UCASE, REVERSE, LPAD, RPAD, kakbi standart funksiyalar asosida so’rovlar yaratish.
5. Agregat funksiyalardan foydalanish (SUM, AVG, MIN, MAX, COUNT, COUNT (*) ).
Baholash mezoni:

Shart	Baho
Masalani yechishda optimal yondashish	2
Masalaning to’liq bajarilganligi	2
Amaliy ish to‘g‘ri tartibda bajarilganligi	2
Himoya qilish	2
Jami	8

Amaliy ish o’z ichiga oladi:

1. 
   Muqova
   
2. 
   Har bir standart so‘z ishtirokidagi so’rov va uning natijasi (screnshotlar)