Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

120. Ko'p shartli korrelyatsion subquery

Qiyin
Subquery'larYandex Go

Narxi o'sha shahardagi va o'sha kundagi safarlarning o'rtacha narxidan

yuqori bo'lgan safarlarni toping.

Diqqat: o'rtacha ikki shart bo'yicha birdan hisoblanadi — faqat shahar yoki

faqat kun bo'yicha emas.

Ustunlar: id, city, trip_day, fare.

Saralash: city alifbo, keyin trip_day o'sish, keyin fare kamayish.

trips: id INT PK, city VARCHAR, trip_day DATE, fare NUMERIC(10,2)

Jadval: trips

UstunTuri
idINT PK
cityVARCHAR(40)
trip_dayDATE
fareNUMERIC(10,2)

Namuna ma'lumotlar

sample
trips
idINTcityVARCHAR(40)trip_dayDATEfareNUMERIC(10,2)
1Toshkent2025-05-0125000
2Toshkent2025-05-0145000
6Samarqand2025-05-0130000
7Samarqand2025-05-0130000
Kutilgan natija
idcityfaretrip_day
2Toshkent450002025-05-01
sample-full
trips
idINTcityVARCHAR(40)trip_dayDATEfareNUMERIC(10,2)
1Toshkent2025-05-0125000
2Toshkent2025-05-0145000
3Toshkent2025-05-0135000
4Toshkent2025-05-0218000
5Toshkent2025-05-0262000
6Samarqand2025-05-0130000
7Samarqand2025-05-0130000
8Samarqand2025-05-0222000
9Samarqand2025-05-0248000
10Samarqand2025-05-0215000
11Buxoro2025-05-0140000
12Buxoro2025-05-0120000
13Buxoro2025-05-0355000
14Andijon2025-05-0133000
Kutilgan natija
idcityfaretrip_day
11Buxoro400002025-05-01
9Samarqand480002025-05-02
2Toshkent450002025-05-01
5Toshkent620002025-05-02
sample-extra
trips
idINTcityVARCHAR(40)trip_dayDATEfareNUMERIC(10,2)
1Samarqand2025-05-0236969.51
2Toshkent2025-05-2620551.68
3Toshkent2025-05-2622000
4Toshkent2025-05-2618500
5Toshkent2025-05-0225000
6Samarqand2025-05-2651944.79
Kutilgan natija
idcityfaretrip_day
3Toshkent220002025-05-26
2Toshkent20551.682025-05-26

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.