Write SQL for Business Tables | Dataford Interview Questions

They gave you input and output tables and asked you to write a SQL query.

Use the provided customers and trips tables to return one row for every customer, summarizing only completed trips. Assign an activity level based on the customer's completed trip count.

Output

Columns: customer_id, customer_name, completed_trip_count, total_completed_fare, and activity_level
Include customers with no completed trips, using zero totals and None as their activity level
Sort by total_completed_fare descending, then customer_id ascending

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name

trips

Column	Type	Description
trip_idPK	INT	Unique trip identifier
customer_id	INT	Customer associated with the trip
status	VARCHAR(20)	Trip status
fare_amount	NUMERIC(10,2)	Fare charged for the trip

Your question is Write SQL for Business Tables. 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