What was the average nightly rate by season? SELECT CASE…
What was the average nightly rate by season? SELECT CASE WHEN MONTH(checkin_date) IN (12,1,2) THEN ‘Winter’ WHEN MONTH(checkin_date) IN (6,7,8) THEN ‘Summer’ ELSE ‘Other’ END AS season, ROUND(AVG(price_per_night), 2) AS avg_priceFROM bookingsGROUP BY seasonORDER BY season DESC; Enter the values for each season. [a] Winter [b] Summer [c] Other
Read Details