It can take days or weeks before a listing is first booked; Write a query to count the daily number of listings that were booked the first time in August 2021. If there are no listings that were first booked during a day, return 0.

Question 120

First ever booking

Unsolved Hard airbnb Lecture

Premium Access

** *** **** **** ** ***** ****** * ******* ** ***** ******;
***** * ***** ** ***** *** ***** ****** ** ******** **** **** ****** *** ***** **** ** ****** 2021.
** ***** *** ** ******** **** **** ***** ****** ****** * ***, ****** 0.

Table 1: bookings

**** ******* ***** * *********** ** ******.

  ***_****    | ***_****
--------------+-------------------
****          | ****
*******_**    | ******
*******_**    | ******

Table 2: dates

******** ***** **** 01/01/2019 ** 12/31/2025.

 ***_**** | ***_****
----------+----------
 ****     | ********
 *****    | ********
 ****     | ****

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

15:00

Timer

Your results

Run your query to preview results here.

Question	Level	FTPR
#118. Daily bookings in the US	Hard	5%
#119. Top 2 countries by bookings	Hard	10%
#121. Week over week change of first ever bookings	Hard	14%
#122. Top country by wow growth	Hard	13%
#123. Top listing in the United States, United Kingdom and Canada	Medium	10%