SQL Repeat Maintenance Hotspots | Dataford Interview Questions

How would you use SQL to identify the top 10 buildings with the highest repeat maintenance requests over the last 90 days?

Use the provided buildings and maintenance requests data. Treat a building as having repeat requests when it has more than one maintenance request during the period.

Output

One row per qualifying building, with building_id, building_name, and repeat_request_count.
Include only buildings with at least two requests in the last 90 days.
Order by request count descending, then building name ascending for ties, and return at most 10 rows.

Schema

buildings

Column	Type	Description
building_idPK	INT	Unique identifier for a campus building
building_name	VARCHAR(100)	Official building name
campus	VARCHAR(50)	Campus where the building is located

maintenance_requests

Column	Type	Description
request_idPK	INT	Unique maintenance request identifier
building_id	INT	Building associated with the request
requested_at	TIMESTAMP	Timestamp when the request was submitted
priority	VARCHAR(20)	Operational priority of the request

Your question is SQL Repeat Maintenance Hotspots. 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.

Problem