Final answer:
To obtain the manager's name and salary for the Waterloo condo project, an SQL query is used to join the 'managers' and 'projects' tables on the common 'manager_id' and filter the result for 'Waterloo Condo'.
Step-by-step explanation:
To list the name of the manager and his/her salary for the Waterloo condo project using SQL, you will need to craft a query that joins the relevant tables containing the manager information and project details. Assuming that we have two tables: 'managers' and 'projects', and these tables have a common field that relates a manager to a specific project, the SQL statement might look something like this:
SELECT m.name AS ManagerName, m.salary AS ManagerSalary
FROM managers m
JOIN projects p ON m.manager_id = p.manager_id
WHERE p.project_name = 'Waterloo Condo';
This query selects the manager's name and salary from the managers table, with a join on the projects table where the manager_id matches in both tables. The WHERE clause is used to filter the results to only include the 'Waterloo Condo' project. Ensure that you replace 'manager_id', 'name', 'salary', and 'project_name' with the actual column names used in your database schema.