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).