Suppose you have the following tables containing information about the buildings a company occupies as well as employee building assignments. Capacity in the "building_info" table refers to the number of employees a given building can seat.
Using the tables above, write a SQL query to return the building_id, building_name, number of empty seats, and the percent of seats occupied for each unique building.
Your output should return the columns listed below and each row in the table should represent a single building.
Subscribe to premium account to see the solution.Get premium now