38. Buyurtma paytida amal qilgan aksiyalar
O'rtachaJOIN'larUzum
Har bir buyurtma uchun o'sha kuni amal qilgan aksiyalarni toping.
Aksiya starts_on dan ends_on gacha amal qiladi (ikkala chegara ham kiradi).
Ustunlar: order_id, customer_name, code.
Bir buyurtmaga bir nechta aksiya to'g'ri kelsa — har biri alohida qatorda.
Aksiya to'g'ri kelmagan buyurtma natijaga kirmaydi.
Saralash: order_id, keyin code.
orders: id, customer_name, order_date DATE
promos: code VARCHAR, starts_on DATE, ends_on DATE
Jadval: orders
| Ustun | Turi |
|---|---|
| id | INT PK |
| customer_name | VARCHAR(60) |
| order_date | DATE |
Jadval: promos
| Ustun | Turi |
|---|---|
| code | VARCHAR(20) PK |
| starts_on | DATE |
| ends_on | DATE |
Namuna ma'lumotlar
sample
orders
| idINT | customer_nameVARCHAR(60) | order_dateDATE |
|---|---|---|
| 1 | Aziz | 2025-03-05 |
| 2 | Nilufar | 2025-04-20 |
promos
| codeVARCHAR(20) | starts_onDATE | ends_onDATE |
|---|---|---|
| BAHOR10 | 2025-03-01 | 2025-03-31 |
| YOZ20 | 2025-06-01 | 2025-06-30 |
Kutilgan natija
| code | order_id | customer_name |
|---|---|---|
| BAHOR10 | 1 | Aziz |
sample-full
orders
| idINT | customer_nameVARCHAR(60) | order_dateDATE |
|---|---|---|
| 1 | Aziz Karimov | 2025-03-05 |
| 2 | Nilufar Rahimova | 2025-04-20 |
| 3 | Bekzod Tursunov | 2025-03-01 |
| 4 | Malika Yusupova | 2025-03-31 |
| 5 | Sardor Nazarov | 2025-05-15 |
| 6 | Dilnoza Ergasheva | 2025-03-15 |
| 7 | Jasur Qodirov | 2025-07-10 |
| 8 | Kamola Saidova | 2025-06-15 |
| 9 | Otabek Mirzayev | 2025-02-28 |
| 10 | Zilola Hamidova | 2025-06-01 |
promos
| codeVARCHAR(20) | starts_onDATE | ends_onDATE |
|---|---|---|
| BAHOR10 | 2025-03-01 | 2025-03-31 |
| YOZ20 | 2025-06-01 | 2025-06-30 |
| MART15 | 2025-03-10 | 2025-03-20 |
| BAHOR-YOZ | 2025-05-01 | 2025-06-10 |
Kutilgan natija
| code | order_id | customer_name |
|---|---|---|
| BAHOR10 | 1 | Aziz Karimov |
| BAHOR10 | 3 | Bekzod Tursunov |
| BAHOR10 | 4 | Malika Yusupova |
| BAHOR-YOZ | 5 | Sardor Nazarov |
| BAHOR10 | 6 | Dilnoza Ergasheva |
| MART15 | 6 | Dilnoza Ergasheva |
| YOZ20 | 8 | Kamola Saidova |
| BAHOR-YOZ | 10 | Zilola Hamidova |
| YOZ20 | 10 | Zilola Hamidova |
sample-extra
orders
| idINT | customer_nameVARCHAR(60) | order_dateDATE |
|---|---|---|
| 2 | Bekzod Usmonov | 2025-06-02 |
| 1 | Sardor Sobirov | 2025-04-01 |
| 4 | Ulug'bek Aliyev | 2025-06-15 |
| 5 | Islom Rahimov | 2025-02-28 |
| 3 | Dilnoza Saidova | 2025-02-23 |
promos
| codeVARCHAR(20) | starts_onDATE | ends_onDATE |
|---|---|---|
| MART15 | 2025-03-28 | 2025-03-28 |
| BAHOR-YOZ | 2025-03-02 | 2025-06-10 |
| YOZ20 | 2025-04-08 | 2025-06-30 |
Kutilgan natija
| code | order_id | customer_name |
|---|---|---|
| BAHOR-YOZ | 1 | Sardor Sobirov |
| BAHOR-YOZ | 2 | Bekzod Usmonov |
| YOZ20 | 2 | Bekzod Usmonov |
| YOZ20 | 4 | Ulug'bek Aliyev |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.