27. Uzum: sotuvchi reytingi (standart qiymat bilan)
OsonSELECT asoslariUzum
Sotuvchilar sellers jadvalida. Yangi sotuvchilarda reyting hali yo'q (NULL).
Har bir sotuvchi uchun shop_name va rating ustunlarini qaytaring, lekin
reyting NULL bo'lsa uning o'rniga 0.0 ko'rsatilsin.
Natija ustuni nomi: rating.
Saralash: rating kamayish, keyin shop_name alifbo.
Jadval: sellers
| Ustun | Turi |
|---|---|
| id | INT PK |
| shop_name | VARCHAR |
| rating | NUMERIC(2,1) NULL |
Namuna ma'lumotlar
sample-basic
sellers
| idINT | shop_nameVARCHAR(80) | ratingNUMERIC(2,1) |
|---|---|---|
| 1 | TechStore | 4.8 |
| 2 | HomeMarket | NULL |
| 3 | FashionHub | 3.5 |
| 4 | BookWorld | 4.8 |
Kutilgan natija
| rating | shop_name |
|---|---|
| 4.8 | BookWorld |
| 4.8 | TechStore |
| 3.5 | FashionHub |
| 0 | HomeMarket |
sample-all-null
sellers
| idINT | shop_nameVARCHAR(80) | ratingNUMERIC(2,1) |
|---|---|---|
| 1 | Alpha | NULL |
| 2 | Beta | NULL |
Kutilgan natija
| rating | shop_name |
|---|---|
| 0 | Alpha |
| 0 | Beta |
sample-single
sellers
| idINT | shop_nameVARCHAR(80) | ratingNUMERIC(2,1) |
|---|---|---|
| 1 | Solo | 4.2 |
Kutilgan natija
| rating | shop_name |
|---|---|
| 4.2 | Solo |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.