1-labaratoriya ishi Mavzu: Ma`lumotlar bazasini loyihalash. Mohiyat – aloqa diagrammasini qurish (er modeli). Ishdan maqsad

Masalan: Select student_ID Max (mark) from exam_marks Group by student_ID;

Guruxlar ichidan kerakli yozuvlarni ajratib olish uchun HAVING ishlatiladi.

Masalan: Select Subj_name, max (hour) From SUBJECT;

Group by Subj_name Having max (Hour)>=34;

Yuqorida keltirib o`tilgan HAVING va GROUP BY standart so`zlaridan foydalanib supermarket predmet sohasining ma`lumotlar bazasi ustida ba`zi bir so`rovlarni yaratamiz.

1. 
   misol: Omborxonada 500 kgdan kam qolgan mahsulotlar haqida ma`lumot berilsin.
   

So`rov: SELECT * FROM `mahsulotlar` HAVING `miqdori(kg)`<500;