Birorta ham buyurtma bermagan mijozlarning ismlarini chiqaring.
Namunaviy ma‘lumotlar
| id integer | name text | city text | phone text |
|---|---|---|---|
| 1 | Temur Xolmatov | Toshkent | +998905886917 |
| 2 | Bobur Xolmatov | Buxoro | +998909079249 |
| 3 | Zarina Karimov | Toshkent | +998903998937 |
| 4 | Aziz Aliyev | Buxoro | +998906808052 |
| 5 | Otabek Mirzayev | Buxoro | +998908030306 |
| 6 | Aziz Toshmatov | Samarqand | +998904670544 |
| 7 | Sardor Umarov | Samarqand | +998906814500 |
| id integer | customer_id integer | order_date text |
|---|---|---|
| 1 | 1 | 2025-03-10 |
| 2 | 1 | 2025-03-11 |
| 3 | 1 | 2025-03-12 |
| 4 | 2 | 2025-06-07 |
| 5 | 2 | 2025-06-08 |
| 6 | 5 | 2025-05-04 |
| 7 | 4 | 2025-09-11 |
| 8 | 4 | 2025-03-04 |
| 9 | 1 | 2025-05-26 |
| 10 | 3 | 2025-10-09 |
| 11 | 2 | 2025-02-14 |
| 12 | 3 | 2025-06-19 |
| 13 | 5 | 2025-03-20 |
| 14 | 2 | 2025-05-03 |
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
Bitta ustun: name.
Namunaviy ma‘lumotlarda kutilgan natija
| Aziz Toshmatov |
| Sardor Umarov |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.