43. Elektronika sotib olgan mijozlar (takrorsiz)
O'rtachaJOIN'larUzum
Elektronika kategoriyasidan kamida bitta mahsulot sotib olgan mijozlarni toping.
Har mijoz bir marta chiqsin — u nechta elektronika mahsuloti olganidan qat'i nazar.
Ustun: customer. Saralash: alifbo.
customers: id, name · orders: id, customer_id
order_items: id, order_id, category VARCHAR
Jadval: customers
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(60) |
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| customer_id | INT |
Jadval: order_items
| Ustun | Turi |
|---|---|
| id | INT PK |
| order_id | INT |
| category | VARCHAR(40) |
Namuna ma'lumotlar
sample-basic
customers
| idINT | nameVARCHAR(60) |
|---|---|
| 1 | Aziz |
| 2 | Nilufar |
| 3 | Bekzod |
orders
| idINT | customer_idINT |
|---|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
order_items
| idINT | order_idINT | categoryVARCHAR(40) |
|---|---|---|
| 1 | 1 | Elektronika |
| 2 | 1 | Elektronika |
| 3 | 2 | Elektronika |
| 4 | 3 | Kiyim |
| 5 | 3 | Elektronika |
| 6 | 4 | Kitob |
Kutilgan natija
| customer |
|---|
| Aziz |
| Nilufar |
sample-none-elektronika
customers
| idINT | nameVARCHAR(60) |
|---|---|
| 1 | Aziz |
orders
| idINT | customer_idINT |
|---|---|
| 1 | 1 |
| 2 | 1 |
order_items
| idINT | order_idINT | categoryVARCHAR(40) |
|---|---|---|
| 1 | 1 | Kiyim |
| 2 | 2 | Kitob |
sample-single
customers
| idINT | nameVARCHAR(60) |
|---|---|
| 1 | Aziz |
orders
| idINT | customer_idINT |
|---|---|
| 1 | 1 |
order_items
| idINT | order_idINT | categoryVARCHAR(40) |
|---|---|---|
| 1 | 1 | Elektronika |
Kutilgan natija
| customer |
|---|
| Aziz |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.