Problem
Write a SQL query to calculate weekly occupancy, average daily rate, and revenue by property using booking and room tables.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
Write a SQL query to calculate weekly occupancy, average daily rate, and revenue by property using booking and room tables.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
