Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

14. Taksi: haydovchilar daromadi reytingi

O'rtacha
AgregatsiyalarWindow funksiyalarYandex Go

Har bir haydovchining shahri ichida umumiy daromadi bo'yicha o'rnini toping.

Qaytaring: city, driver_name, total_earned, rank_in_city.

  • total_earned — haydovchining barcha safarlari narxi yig'indisi
  • rank_in_city — shahar ichida daromad bo'yicha o'rin (eng ko'p = 1).

Teng daromadda bir xil o'rin berilsin va keyingi o'rin o'tkazib yuborilmasin

(ya'ni DENSE_RANK).

Safar qilmagan haydovchilar natijaga kirmaydi.

Saralash: city o'sish, rank_in_city o'sish, driver_name o'sish.

Jadvallar

drivers: id INT PK, name VARCHAR, city VARCHAR

trips: id INT PK, driver_id INT, price NUMERIC(10,2)

Jadval: drivers

UstunTuri
idINT PK
nameVARCHAR(50)
cityVARCHAR(50)

Jadval: trips

UstunTuri
idINT PK
driver_idINT
priceNUMERIC(10,2)

Namuna ma'lumotlar

sample-basic
drivers
idINTnameVARCHAR(50)cityVARCHAR(50)
1AzizToshkent
2BekToshkent
3DilnozaBuxoro
trips
idINTdriver_idINTpriceNUMERIC(10,2)
1150000
2145000
3120000
4230000
5265000
6220000
7370000
8325000
Kutilgan natija
citydriver_namerank_in_citytotal_earned
BuxoroDilnoza195000
ToshkentAziz1115000
ToshkentBek1115000
sample-single-driver
drivers
idINTnameVARCHAR(50)cityVARCHAR(50)
1AzizToshkent
trips
idINTdriver_idINTpriceNUMERIC(10,2)
1195000
Kutilgan natija
citydriver_namerank_in_citytotal_earned
ToshkentAziz195000
sample-tie-in-city
drivers
idINTnameVARCHAR(50)cityVARCHAR(50)
1AzizBuxoro
2BekBuxoro
trips
idINTdriver_idINTpriceNUMERIC(10,2)
1195000
2295000
Kutilgan natija
citydriver_namerank_in_citytotal_earned
BuxoroAziz195000
BuxoroBek195000

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.