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

SIMULATION -You have a database that contains the following tables. You need to create a query that returns each complaint, the names of the employees handling the complaint, and the notes on each interaction. The Complaint field must be displayed first, followed by the employee's name and the notes. Complaints must be returned even if no interaction has occurred. Construct the query using the following guidelines: ✑ Use two-part column names. ✑ Use one-part table names. ✑ Use the first letter of the table name as its alias. ✑ Do not Transact-SQL functions. ✑ Do not use implicit joins. ✑ Do not surround object names with square brackets. Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it. 1 SELECT c.Complaint, e.Name, i.Notes2 FROM Complaints c3 JOIN __________________4 JOIN __________________

1. A. Please see explanation 1 SELECT c.Complaint, e.Name, i.Notes 2 FROM Complaints c 3 JOIN Interactions i ON c.ComplaintID = i.ComplaintID 4 JOIN Employees e ON i.EmployeeID = E.EmployeeID — đáp án hiện tại