30. Express24: buyurtma kelmagan restoranlar
OsonJOIN'larExpress24
Hech qanday buyurtma kelmagan restoranlarning restaurant (nomi) ustunini qaytaring.
Saralash: nom bo'yicha alifbo.
restaurants: id INT PK, name VARCHAR, district VARCHAR
orders: id INT PK, restaurant_id INT, total NUMERIC(12,2)
Jadval: restaurants
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(80) |
| district | VARCHAR(50) |
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| restaurant_id | INT |
| total | NUMERIC(12,2) |
Namuna ma'lumotlar
sample-basic
restaurants
| idINT | nameVARCHAR(80) | districtVARCHAR(50) |
|---|---|---|
| 1 | Osh Markazi | Chilonzor |
| 2 | Milano Pizza | Yunusobod |
| 3 | Burger House | Yakkasaroy |
orders
| idINT | restaurant_idINT | totalNUMERIC(12,2) |
|---|---|---|
| 1 | 1 | 50000 |
| 2 | 1 | 30000 |
Kutilgan natija
| restaurant |
|---|
| Burger House |
| Milano Pizza |
sample-all-no-orders
restaurants
| idINT | nameVARCHAR(80) | districtVARCHAR(50) |
|---|---|---|
| 1 | Choyxona 1 | Shayxontohur |
| 2 | Sushi Time | Chilonzor |
Kutilgan natija
| restaurant |
|---|
| Choyxona 1 |
| Sushi Time |
sample-all-have
restaurants
| idINT | nameVARCHAR(80) | districtVARCHAR(50) |
|---|---|---|
| 1 | Kebab Point | Yunusobod |
orders
| idINT | restaurant_idINT | totalNUMERIC(12,2) |
|---|---|---|
| 1 | 1 | 40000 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.