SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

Select

D.driver_id ,

U.city,

Average (d.rating) as average -rating,

Count(*) as ride_count

From drivers as d

Joins users as u on d.user_id=u.user_id

Group by

D.driver_id

U.city

order by

Average_rating desc,

Ride_count desc

Limit 100;