Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

34. Taksi: bir kunda ishlagan haydovchi juftlari

O'rtacha
JOIN'larYandex Go

Bir xil kunda safar qilgan haydovchi juftlarini toping.

Har juft bir marta chiqsin: driver_a alifbo bo'yicha driver_b dan oldin bo'lsin

(ya'ni "Aziz–Bekzod" bo'ladi, "Bekzod–Aziz" bo'lmaydi). Haydovchi o'zi bilan juftlashmaydi.

Ustunlar: driver_a, driver_b, trip_date.

Saralash: trip_date, driver_a, driver_b.

trips: id INT PK, driver_name VARCHAR, trip_date DATE

Jadval: trips

UstunTuri
idINT PK
driver_nameVARCHAR(60)
trip_dateDATE

Namuna ma'lumotlar

sample
trips
idINTdriver_nameVARCHAR(60)trip_dateDATE
1Aziz2025-05-01
2Bekzod2025-05-01
3Aziz2025-05-02
Kutilgan natija
driver_adriver_btrip_date
AzizBekzod2025-05-01
sample-full
trips
idINTdriver_nameVARCHAR(60)trip_dateDATE
1Aziz Karimov2025-05-01
2Bekzod Tursunov2025-05-01
3Aziz Karimov2025-05-01
4Aziz Karimov2025-05-02
5Sardor Nazarov2025-05-02
6Jasur Qodirov2025-05-02
7Feruza Sobirova2025-05-03
8Otabek Mirzayev2025-05-04
9Rustam Aliyev2025-05-04
10Zilola Hamidova2025-05-05
11Kamola Saidova2025-05-05
12Dilnoza Ergasheva2025-05-05
Kutilgan natija
driver_adriver_btrip_date
Aziz KarimovBekzod Tursunov2025-05-01
Aziz KarimovJasur Qodirov2025-05-02
Aziz KarimovSardor Nazarov2025-05-02
Jasur QodirovSardor Nazarov2025-05-02
Otabek MirzayevRustam Aliyev2025-05-04
Dilnoza ErgashevaKamola Saidova2025-05-05
Dilnoza ErgashevaZilola Hamidova2025-05-05
Kamola SaidovaZilola Hamidova2025-05-05
sample-extra
trips
idINTdriver_nameVARCHAR(60)trip_dateDATE
5Feruza Valiyeva2025-05-25
1Feruza Valiyeva2025-04-28
2Sardor Tursunov2025-05-25
4Otabek Zokirov2025-04-28
3Feruza Valiyeva2025-04-28
Kutilgan natija
driver_adriver_btrip_date
Feruza ValiyevaOtabek Zokirov2025-04-28
Feruza ValiyevaSardor Tursunov2025-05-25

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.