7. Hech buyurtma bermagan mijozlar
Osoncustomers (id, name) va orders (id, customer_id) jadvallari berilgan.
Vazifa: hech qachon buyurtma bermagan mijozlarning ismini qaytaring. Natija ustuni: customer, customer bo'yicha o'sish tartibida.
Jadval: customers
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| customer_id | INT |
Namuna ma'lumotlar
sample-main
customers
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Ali |
| 2 | Vali |
| 3 | Guli |
orders
| idINT | customer_idINT |
|---|---|
| 10 | 1 |
| 11 | 1 |
| 12 | 3 |
Kutilgan natija
| customer |
|---|
| Vali |
sample-none
customers
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | A |
| 2 | B |
| 3 | C |
Kutilgan natija
| customer |
|---|
| A |
| B |
| C |
sample-mix
customers
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Anvar |
| 2 | Bobur |
| 3 | Zarina |
| 4 | Kamron |
orders
| idINT | customer_idINT |
|---|---|
| 1 | 2 |
| 2 | 2 |
| 3 | 4 |
Kutilgan natija
| customer |
|---|
| Anvar |
| Zarina |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.