2. MIN() – eng kichik qiymatni chiqarish
MAX() – eng katta qiymatni chiqarish
“reyting” jadvalidagi har bir filmning eng past va eng yuqori olgan ballarini topamiz;
select yosh,count(yosh),max(maoshi) from hodimlar group by yosh;
select yosh,count(yosh),min(maoshi) from hodimlar group by yosh;
3. Bu funksiyalarga qo‘shimcha ravishda quyidagi funksiyalarni ham ko‘rib chiqamiz: Rand() - tasodifiy son.
ROUND() - Butun sonni yaxlitlash funktsiyasi.
POWER() - Sonning darajasini hisoblash.
select hodim_id,FISH,RAND(hodim_id),round(rand(hodim_id),2) from hodimlar;
10.3– rasm. Rand(), Round() va Power() funksiyalaridan foydalanish
POWER()-Sonningdarajasinihisoblash.
select hodim_id,FISH,yosh,ish_staji_yili,power(yosh,ish_staji_yili) from hodimlar;
4. SQRT() - Sonning kvadrat ildizini topish.
SIN() - Ifoda sinusini hisoblash.
LOG()- Sonnig natural logarifmni hisoblash.
select hodim_id,sqrt(hodim_id),round(sqrt(hodim_id),3) from hodimlar;
10.4– rasm. Sin(), Sqrt() va Log() funksiyalaridan foydalanish
select hodim_id,log(hodim_id),round(log(hodim_id),3)from hodimlar;
select*from hodimlar where hodim_id between 2 and 4;
5. Filmlar va reytinglar jadvallarini birlashtirib film nomi, ovoz bergan tomoshabinlar soni va ballar yeg‘indisini group by yordamida gurpalab, order by bilan ballar yeg‘indisi bo‘yicha kamayish tartibi topilsin;
select hodimlar.FISH, count(sotuvchilar.s_id), sum(hodimlar.yosh) from hodimlar inner join sotuvchilar on hodimlar.hodim_id=sotuvchilar.s_id group by hodimlar.hodim_id order by sum(hodimlar.yosh) desc;
select mid(FISH,1,3)'HARFLAR',FISH from hodimlar;
|