-- product_id is the primary key for this table. -- period_start and period_end indicates the start and end date for sales period, both dates are inclusive. -- The average_daily_sales column holds the ...
-- This is the most fundamental operational query. It filters out spaces that -- are non-bookable (Under Maintenance, Temporarily Closed, Retired) and -- spaces that already have an ...