Analysing relationships

In this first exercise you are tasked to analyze pricing patterns in Airbnb data to inform strategies for optimizing revenue and meeting customer preferences.

Your workspace should already include the cleaned airbnb_combined table from Chapter 1 (it is pre-provisioned for new sessions). If you are returning after a break, start by confirming that table is available before calculating pricing metrics.

In this exercise, you will use SQL to calculate key pricing metrics—minimum, maximum, and average prices—for different room types. This analysis will help you identify which room types command higher prices and uncover trends in pricing variability.