28. Uzum: buyurtma → mahsulot → sotuvchi
OsonJOIN'larUzum
Uzum da uch jadval bor: orders, products, sellers.
Har bir buyurtma uchun mahsulot nomi va sotuvchi do'koni nomini qaytaring:
order_id, product, seller.
Saralash: order_id o'sish.
orders: id INT PK, product_id INT, quantity INT
products: id INT PK, name VARCHAR, seller_id INT
sellers: id INT PK, shop_name VARCHAR
Jadval: sellers
| Ustun | Turi |
|---|---|
| id | INT PK |
| shop_name | VARCHAR(80) |
Jadval: products
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(100) |
| seller_id | INT |
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| product_id | INT |
| quantity | INT |
Namuna ma'lumotlar
sample-basic
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | TechStore |
| 2 | HomeMarket |
products
| idINT | nameVARCHAR(100) | seller_idINT |
|---|---|---|
| 1 | Quloqchin | 1 |
| 2 | Choynak | 2 |
| 3 | Sichqoncha | 1 |
orders
| idINT | product_idINT | quantityINT |
|---|---|---|
| 1 | 1 | 2 |
| 2 | 3 | 1 |
| 3 | 2 | 5 |
Kutilgan natija
| seller | product | order_id |
|---|---|---|
| TechStore | Quloqchin | 1 |
| TechStore | Sichqoncha | 2 |
| HomeMarket | Choynak | 3 |
sample-single
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | BookWorld |
products
| idINT | nameVARCHAR(100) | seller_idINT |
|---|---|---|
| 1 | Kitob | 1 |
orders
| idINT | product_idINT | quantityINT |
|---|---|---|
| 1 | 1 | 3 |
Kutilgan natija
| seller | product | order_id |
|---|---|---|
| BookWorld | Kitob | 1 |
sample-chain
sellers
| idINT | shop_nameVARCHAR(80) |
|---|---|
| 1 | ToyLand |
products
| idINT | nameVARCHAR(100) | seller_idINT |
|---|---|---|
| 1 | Qo‘g‘irchoq | 1 |
| 2 | To‘p | 1 |
orders
| idINT | product_idINT | quantityINT |
|---|---|---|
| 1 | 2 | 1 |
| 2 | 1 | 4 |
Kutilgan natija
| seller | product | order_id |
|---|---|---|
| ToyLand | To‘p | 1 |
| ToyLand | Qo‘g‘irchoq | 2 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.
