SQL INTERVIEW QUESTION | Hotel Booking Management

DML: datasculptor.b...
Feedback: forms.gle/NQuC...
Playlists:
SQL Interview Questions: • SQL Interview questions
Recursive CTE: • Recursive CTE
PySpark Interview Questions: • PySpark Interview Ques...
Power BI and DAX: • Power BI and DAX
Data Modeling: • Data Modelling
Generative AIs: • Generative AIs
Excel: • Excel
Cricket: • Cricket
SQL ADVANCED AGGREGATIONS: • ADVANCED AGGREGATIONS SQL
Follow me
Linkedin: / data-sculptor-93a00b2a8
Instagram: / datasculptor2895

[@harshitsalecha221]

WITH recursive cte1 AS (SELECT '2024-01-01' as Bookingdate UNION ALL SELECT date_add(Bookingdate, interval 1 day) as Bookingdate FROM cte1 WHERE date_add(Bookingdate, interval 1 day) BETWEEN (SELECT min(bookingdate) FROM bookings) AND (SELECT max(bookingdate) FROM bookings)), cte2 AS (SELECT DISTINCT c1.bookingdate bookingdate, b.roomnumber FROM bookings b,cte1 c1) SELECT c2.bookingdate,c2.roomnumber FROM cte2 as c2 LEFT JOIN bookings b ON c2.bookingdate=b.bookingdate AND c2.roomnumber=b.roomnumber WHERE b.bookingdate is null AND b.roomnumber is null ORDER BY roomnumber,bookingdate;