39. Kamida bitta sharhi bor sotuvchilar
O'rtachaKamida bitta sharh olgan sotuvchilarning shop_name ustunini qaytaring.
Har sotuvchi bir marta chiqsin — sharhlar soni ahamiyatsiz.
Saralash: shop_name alifbo.
sellers: id INT PK, shop_name VARCHAR
reviews: id INT PK, seller_id INT, rating INT
Jadval: sellers
| Ustun | Turi |
|---|---|
| id | INT PK |
| shop_name | VARCHAR(80) |
Jadval: reviews
| Ustun | Turi |
|---|---|
| id | INT PK |
| seller_id | INT |
| rating | INT |
Namuna ma'lumotlar
sample-basic
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | TechnoMarket |
| 2 | Kitob Uyi |
| 3 | Sport Olami |
reviews
| idINT | seller_idINT | ratingINT |
|---|---|---|
| 1 | 1 | 5 |
| 2 | 1 | 4 |
| 3 | 1 | 2 |
| 4 | 2 | 3 |
Kutilgan natija
| shop_name |
|---|
| Kitob Uyi |
| TechnoMarket |
sample-none-reviewed
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | A |
| 2 | B |
sample-all-reviewed
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | X |
| 2 | Y |
reviews
| idINT | seller_idINT | ratingINT |
|---|---|---|
| 1 | 1 | 5 |
| 2 | 2 | 4 |
| 3 | 2 | 3 |
Kutilgan natija
| shop_name |
|---|
| X |
| Y |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.