45. Yetkazish manzili (zaxira qiymat bilan)
O'rtachaJOIN'larExpress24
Buyurtmada maxsus yetkazish manzili ko'rsatilmagan bo'lsa (delivery_address — NULL),
mijozning standart manzili ishlatiladi.
Har buyurtma uchun qaytaring: order_id, customer, address.
Saralash: order_id o'sish.
customers: id, name, default_address VARCHAR
orders: id, customer_id, delivery_address VARCHAR NULL
Jadval: customers
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(60) |
| default_address | VARCHAR(120) |
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| customer_id | INT |
| delivery_address | VARCHAR(120) |
Namuna ma'lumotlar
sample-basic
customers
| idINT | nameVARCHAR(60) | default_addressVARCHAR(120) |
|---|---|---|
| 1 | Aziz | Chilonzor 12 |
| 2 | Nilufar | Yunusobod 4 |
orders
| idINT | customer_idINT | delivery_addressVARCHAR(120) |
|---|---|---|
| 1 | 1 | NULL |
| 2 | 1 | Ish: Amir Temur 5 |
| 3 | 2 | NULL |
Kutilgan natija
| address | customer | order_id |
|---|---|---|
| Chilonzor 12 | Aziz | 1 |
| Ish: Amir Temur 5 | Aziz | 2 |
| Yunusobod 4 | Nilufar | 3 |
sample-all-null
customers
| idINT | nameVARCHAR(60) | default_addressVARCHAR(120) |
|---|---|---|
| 1 | Aziz | Uy 1 |
orders
| idINT | customer_idINT | delivery_addressVARCHAR(120) |
|---|---|---|
| 1 | 1 | NULL |
| 2 | 1 | NULL |
Kutilgan natija
| address | customer | order_id |
|---|---|---|
| Uy 1 | Aziz | 1 |
| Uy 1 | Aziz | 2 |
sample-all-custom
customers
| idINT | nameVARCHAR(60) | default_addressVARCHAR(120) |
|---|---|---|
| 1 | Bek | Uy 2 |
orders
| idINT | customer_idINT | delivery_addressVARCHAR(120) |
|---|---|---|
| 1 | 1 | Ofis A |
| 2 | 1 | Ofis B |
Kutilgan natija
| address | customer | order_id |
|---|---|---|
| Ofis A | Bek | 1 |
| Ofis B | Bek | 2 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.