How should you complete the Transact-SQL statement?

HOTSPOT

You query a database that includes two tables: Project and Task.

The Project table includes the following columns:

You need to identify the owner of each task by using the following rules:

– Return each task’s owner if the task has an owner.

– If a task has no owner, but is associated with a project that has an owner, return the project’s owner.

– Return the value -1 for all other cases.

How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.

View Answer

Answer: