SQL Aggregations and HAVING | Dataford Interview Questions

Tell me about a time you solved practical business scenarios using aggregate functions, HAVING filters, and GROUP BY in SQL.

Use the provided schema and sample data to demonstrate a practical answer. Return drivers with at least two completed trips and at least 100 in total fare.

Output

One row per qualifying driver with driver_name, city, completed_trip_count, total_fare, and average_fare.
Include only completed trips when calculating the metrics.
Order by total_fare descending, then driver_name ascending for ties.

Schema

drivers

Column	Type	Description
driver_idPK	INT	Unique driver identifier
driver_name	VARCHAR(100)	Driver display name
city	VARCHAR(80)	Primary operating city

trips

Column	Type	Description
trip_idPK	INT	Unique trip identifier
driver_id	INT	Driver assigned to the trip
status	VARCHAR(20)	Trip status
fare	DECIMAL(10,2)	Fare amount for the trip

Your question is SQL Aggregations and HAVING. 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