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.
building_info
| building_id | location | building_name | capacity |
|---|---|---|---|
| 00001 | New York | US-NY-01 | 50 |
New to InterviewQs? Sign up now.
By proceeding, you agree to our Terms and Conditions and Privacy Policy.
Loading editor...