Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP
A database contains tables as shown in the exhibit. (Click the Exhibit button.)
Customer who are inactive are moved from the Customers table to the InactiveCustomers table. Any orders for inactive customers are removed from the Orders table.
You write the following SELECT statement to return all the inactive customers:
SELECT CustomerId FROM InactiveCustomers
You need to extend the SELECT statement to include customers who do not have any orders.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Exhibit

Select and Place:

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.