Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

16. Taksi: safarlar orasidagi eng uzun tanaffus

Qiyin
Window funksiyalarCTE & RecursiveYandex Go

Har bir haydovchi uchun ketma-ket safarlar orasidagi eng uzun tanaffusni

kunlarda hisoblang.

Qaytaring: driver_name, max_gap_days.

  • Tanaffus = keyingi safar sanasi − oldingi safar sanasi (kunlarda)
  • Kamida 2 ta safari bo'lgan haydovchilargina natijaga kiradi
  • Bir kunda bir nechta safar bo'lsa, tanaffus 0 bo'lishi mumkin

Saralash: max_gap_days kamayish, driver_name o'sish.

Jadval: trips

UstunTuri
idINT PK
driver_nameVARCHAR
trip_dateDATE

Namuna ma'lumotlar

sample
trips
idINTdriver_nameVARCHAR(50)trip_dateDATE
1Aziz2025-01-01
2Aziz2025-01-10
3Aziz2025-01-12
4Bekzod2025-01-05
Kutilgan natija
driver_namemax_gap_days
Aziz9
sample-full
trips
idINTdriver_nameVARCHAR(50)trip_dateDATE
1Aziz Karimov2025-01-01
2Aziz Karimov2025-01-10
3Aziz Karimov2025-01-12
4Bekzod Tursunov2025-01-05
5Sardor Nazarov2025-01-03
6Sardor Nazarov2025-02-20
7Sardor Nazarov2025-02-21
8Jasur Qodirov2025-01-07
9Jasur Qodirov2025-01-07
10Jasur Qodirov2025-01-15
11Otabek Mirzayev2025-03-01
12Otabek Mirzayev2025-03-04
13Otabek Mirzayev2025-03-09
14Otabek Mirzayev2025-03-10
15Feruza Sobirova2025-01-20
16Feruza Sobirova2025-04-15
Kutilgan natija
driver_namemax_gap_days
Feruza Sobirova85
Sardor Nazarov48
Aziz Karimov9
Jasur Qodirov8
Otabek Mirzayev5
sample-extra
trips
idINTdriver_nameVARCHAR(50)trip_dateDATE
1Bobur Valiyev2025-01-10
2Laylo Fayzullayeva2025-03-11
3Dilnoza Abdullayeva2025-01-10
4Nigora Sultonova2025-03-11
5Bobur Valiyev2025-01-10
Kutilgan natija
driver_namemax_gap_days
Bobur Valiyev0

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.