You are a database developer for Contoso, Ltd.
The company has a database named HumanResources that contains information about all employees and office locations.
The database also contains information about potential employees and office locations.
The tables that ontain this information are shown in the exhibit.
Current employees are assigned to a location, and current locations have one or more employees assigned to them.
Potential employees are not assigned to a location, and potential office locations do not have any employees assigned to them.
You need to create a report to display all current and potential employees and office locations. The report should list each current and potential location, followed by any employees who have been assigned to that location.
Potential employees should be listed together.
Which script should you use?