Har bir buyurtma uchun uning raqamini (orders.id), sanasini va buyurtma bergan mijozning ismini chiqaring.
Namunaviy ma‘lumotlar
| id integer | name text | city text | phone text |
|---|---|---|---|
| 1 | Elyor Mirzayev | Samarqand | +998903036671 |
| 2 | Jasur Ergashev | Samarqand | +998902418114 |
| 3 | Gulnora Qodirov | Buxoro | +998902141442 |
| 4 | Yusuf Nazarov | Toshkent | +998907025904 |
| 5 | Farrux Karimov | Buxoro | +998902037990 |
| 6 | Umida Qodirov | Toshkent | +998906304922 |
| 7 | Farrux Mirzayev | Samarqand | NULL |
| id integer | customer_id integer | order_date text |
|---|---|---|
| 1 | 1 | 2025-03-25 |
| 2 | 1 | 2025-03-26 |
| 3 | 1 | 2025-03-27 |
| 4 | 2 | 2025-06-18 |
| 5 | 2 | 2025-06-19 |
| 6 | 4 | 2025-09-14 |
| 7 | 1 | 2025-01-27 |
| 8 | 2 | 2025-04-28 |
| 9 | 4 | 2025-02-15 |
| 10 | 2 | 2025-05-21 |
| 11 | 2 | 2025-05-05 |
| 12 | 2 | 2025-06-06 |
| 13 | 2 | 2025-10-12 |
| 14 | 4 | 2025-06-11 |
Jadval tuzilishi (CREATE TABLE)
CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, city TEXT, phone TEXT); CREATE TABLE orders (id INTEGER PRIMARY KEY, customer_id INTEGER, order_date TEXT);
Natija
Uch ustun: order_id, order_date, customer_name.
Namunaviy ma‘lumotlarda kutilgan natija
| 1 | 2025-03-25 | Elyor Mirzayev |
| 2 | 2025-03-26 | Elyor Mirzayev |
| 3 | 2025-03-27 | Elyor Mirzayev |
| 4 | 2025-06-18 | Jasur Ergashev |
| 5 | 2025-06-19 | Jasur Ergashev |
| 6 | 2025-09-14 | Yusuf Nazarov |
| 7 | 2025-01-27 | Elyor Mirzayev |
| 8 | 2025-04-28 | Jasur Ergashev |
| 9 | 2025-02-15 | Yusuf Nazarov |
| 10 | 2025-05-21 | Jasur Ergashev |
| 11 | 2025-05-05 | Jasur Ergashev |
| 12 | 2025-06-06 | Jasur Ergashev |
| 13 | 2025-10-12 | Jasur Ergashev |
| 14 | 2025-06-11 | Yusuf Nazarov |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.