Rank Sitters by City | Dataford Interview Questions

Write a query using window functions to rank sitters in each city based on their average rating and total completed bookings.

Use the sitters and bookings tables. Include sitters with at least one completed booking, even when their completed bookings have no rating.

Output

One row per eligible sitter with city, sitter_id, sitter_name, average_rating, completed_bookings, and city_rank.
Rank within each city by average rating descending, then completed bookings descending. Place unrated sitters after rated sitters.
Order by city, city_rank, and sitter_id.

sitters

Column	Type	Description
sitter_idPK	INT	Unique identifier for the sitter
sitter_name	VARCHAR(100)	Sitter display name
city	VARCHAR(100)	City where the sitter provides services

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
sitter_id	INT	Sitter assigned to the booking
status	VARCHAR(30)	Booking status
rating	DECIMAL(3,2)	Customer rating for the booking

Your question is Rank Sitters by City. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.