SQL Data Manipulation | Dataford Interview Questions

Describe how you would solve a regular SQL data manipulation problem involving subqueries with calculations, conditions, and concatenation.

Use the provided customer and booking data. Return customers with at least two completed bookings and more than 500 in completed booking value. Concatenate the customer's first and last names, handling a missing last name.

Output

One row per qualifying customer with customer_name, city, completed_bookings, and total_completed_value
Exclude customers who do not meet either condition
Order by total_completed_value descending, then customer_name ascending

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
first_name	VARCHAR(80)	Customer first name
last_name	VARCHAR(80)	Customer last name
city	VARCHAR(80)	Customer home city

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
customer_id	INT	Customer who made the booking
status	VARCHAR(20)	Booking lifecycle status
amount	NUMERIC(10,2)	Booking value

Your question is SQL Data Manipulation. 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