SQL for User Booking Data | Dataford Interview Questions

Create a SQL query to extract user booking data for analysis.

Return every booking as one result row, preserving NULL values where the source data has them. Sort the results by user, booking date, and booking ID.

Output

One row per booking
Columns: booking_id, user_id, booking_date, destination, booking_status, and total_amount
Sort by user_id ascending, booking_date ascending, and booking_id ascending

Schema

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
user_id	INT	Identifier of the user who made the booking
booking_date	DATE	Date when the booking was created
destination	VARCHAR(100)	Booking destination
booking_status	VARCHAR(30)	Current status of the booking
total_amount	DECIMAL(10,2)	Total booking amount

Your question is SQL for User Booking Data. Start with the requirements and the one table 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