Calculating cost per square foot
You're given the following tables that have information about a real estate portfolio. The tables provide information on building size and total cost.
Using the tables above, write a SQL query that calculates the average total cost per square foot for each building. In the "building_cost" table you'll have to add both the rent and the janitorial cost in order to calculate total cost.
You can view/query the data in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now