Office space capacity

Question

You are given a table of office sites owned by your company called office_locations, as well as a table with active headcount called company_headcount.

office_locations

office_location The unique location code for the office, varchar
headcount_capacity The headcount capacity of the given location, int

company_headcount

office_location The unique location code for the office, varchar
active_headcount The active headcount seated in the given location, int

Using these two tables, write a SQL query to highlight the utilization rate (active headcount / site capacity) for each office location owned by your company. You can assume each row represents a unique location in the two tables (e.g. a given location is not repeated multiple times).

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now