Q1 booking check

EasyAirbnbdate mathconditional sumsaverage daily ratejoins· 20 XP (10 per step)

Mock interview. You're interviewing for a data analyst job on a home-sharing marketplace team. The interviewer shares bookings and listings. "Let's see how stays starting in Q1 2026 went."

A stay's nights are checkout_date - checkin_date.
Average daily rate (ADR) is revenue divided by nights, for confirmed stays.
Look at bookings with a checkin_date from 1 January to 31 March 2026.

Step 1: The headline numbers

"In one row: confirmed bookings, their nights, their revenue (total_price), the ADR, and the cancellation rate of all Q1 bookings."

Expected output

Return: bookings, nights, revenue, adr and cancel rate (name the columns however you like)

One row; adr rounded to 2 decimals; cancel_rate as a percentage rounded to 1 decimal

Example of the shape (made-up values):

bookings	nights	revenue	adr	cancel_rate
400	1500	195000.00	130.00	12.0

Step 1 of 2

Write your query here. Ctrl + Enter submits.