10. Taksi: safarlar va haydovchilar
OsonJOIN'larYandex Go
Taksi xizmatida drivers (haydovchilar) va trips (safarlar) jadvallari bor.
Har bir safar uchun haydovchi ismini va safar narxini qaytaring:
driver_name, city, price.
Natijani narx bo'yicha kamayish tartibida saralang.
Jadvallar
drivers: id INT PK, name VARCHAR, city VARCHAR
trips: id INT PK, driver_id INT, price NUMERIC(10,2)
Jadval: drivers
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
| city | VARCHAR(50) |
Jadval: trips
| Ustun | Turi |
|---|---|
| id | INT PK |
| driver_id | INT |
| price | NUMERIC(10,2) |
Namuna ma'lumotlar
sample-basic
drivers
| idINT | nameVARCHAR(50) | cityVARCHAR(50) |
|---|---|---|
| 1 | Aziz | Toshkent |
| 2 | Bek | Samarqand |
trips
| idINT | driver_idINT | priceNUMERIC(10,2) |
|---|---|---|
| 1 | 1 | 45000 |
| 2 | 2 | 30000 |
| 3 | 1 | 60000 |
Kutilgan natija
| city | price | driver_name |
|---|---|---|
| Toshkent | 60000 | Aziz |
| Toshkent | 45000 | Aziz |
| Samarqand | 30000 | Bek |
sample-single-trip
drivers
| idINT | nameVARCHAR(50) | cityVARCHAR(50) |
|---|---|---|
| 1 | Solo | Xiva |
trips
| idINT | driver_idINT | priceNUMERIC(10,2) |
|---|---|---|
| 1 | 1 | 25000 |
Kutilgan natija
| city | price | driver_name |
|---|---|---|
| Xiva | 25000 | Solo |
sample-no-trips
drivers
| idINT | nameVARCHAR(50) | cityVARCHAR(50) |
|---|---|---|
| 1 | Idle | Nukus |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.