You develop a Microsoft SQL Server database that contains tables as shown in the exhibit. (Click the Exhibit button.)
You need to retrieve a list of clients for whom there is no corresponding information in the Projects table.
Which Transact-SQL statements should you run?
A)
B)
C)
D)
A . Option A
B . Option B
C . Option C
D . Option D
Answer: A
Explanation:
References: https://www.dofactory.com/sql/select-distinct https://www.dofactory.com/sql/right-outer-join