8 |
1200 |
| 2 | IPhone 12 pro MAX | Apple |
7 |
900 |
| 3 | IPhone 11 pro MAX | Apple |
12 |
800 |
| 4 | Galaxy S21 Ultra | Samsung |
10 |
1000 |
| 5 | Honor 7 plus
| Honor |
18 |
500 |
| 6 | Redmi Note 9 Pro | Xiaomi |
16 |
450 |
| 7 | Huawei P 30 Lite | Huawei |
13 |
300 |
| 8 | Redmi 10 T
| Xiaomi |
0 |
457 |
| 9 | Miui 12 Ultra
| Xiaomi |
0 |
412 |
+----+-------------------+---------+--------------+---------------+
select count(*) as soni,
-> sum(Maxsulotsoni*Maxsulotnarxi) as narxi,
-> max(Maxsulotnarxi) as qimmat,
-> min(Maxsulotnarxi) as arzon,
-> avg(Maxsulotnarxi) as orta from products;
+------+-------+--------+-------+------------------+
| soni | narxi | qimmat | arzon | orta
|
+------+-------+--------+-------+------------------+
| 9 | 55600 | 1200 | 300 | 668.777777777778 |
+------+-------+--------+-------+------------------+
7. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha
STANDART FUNKSIYALARDAN foydalanib so’rovlar yaratishi va
natijasi bilan ko’rsatib o’tishi kerak.
Select * CONCAT(Maxsulotnomi,'- ',SUBSTR(UPPER(Brendi),1,2))as
UMUMIY from products;
+----------------------+
| UMUMIY
|
+----------------------+
| IPhone 13 pro MAX-AP |
Dostları ilə paylaş: |
