Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Course Recap
5. Adding a column
Final challenge


Great! Now that our data set is preprocessed, let's add a new column.


Create a new column named price_per_person, calculated as the price divided by accommodates.

Sort all rows by the new column. You can see that some places can be extremely cheap, costing around 1-2 NZD per person.

Stuck? Here's a hint!

To define a new column, simply start with:

airbnb_dataset['price_per_person'] = ...