There are multiple questions:
-
The operating regions are indicated by region_id. Generate a report of the average hourly_charge in each operating region as well as the overall average.
-
Assuming that a booking is completed if it is not cancelled by the customer and has no reschedule events, generate a report based on the calendar week (running Sun-Sat) of the number of bookings done, number of bookings done using coupons, total hours booked, and number of bookings which were cancelled by the customer.
-
Recurring bookings are bookings which happen on a regularly scheduled basis and are indicated by recurring_id and a frequency (freq) indicating how many weeks pass between each booking in the series. Determine the distribution of bookings based on the frequency of the recurring booking to which they belong across the days of the week on which they were completed.
-
Say we have a problem with customers canceling and rescheduling bookings. Assuming all the bookings are from different users, pull metric