Suppose you work for Airbnb as an analyst. A team has come to you asking which cities generate the highest revenue for the company in 2017. Using the schemas below, write a SQL query to answer this question.

You have a table with property location information and another table with stay information. The schema of the tables are below:

Table: property_location_info

| Column Name | Data Type | Description |...