Câu 17: 70-761: Querying Data with Transact-SQL

HOTSPOT -Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. 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-1for all other cases. How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area. Hot Area:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại