Exam 70-761 topic 1 question 155 discussion

Actual exam question from Microsoft's 70-761

Question #: 155
Topic #: 1

You have a database that includes the tables shown in the exhibit. (Click the exhibit button.)

You need to create a list of all customers and the date that the customer placed their last order. For customers who have not placed orders, you must substitute
01/01/1990 for the date.
Which Transact-SQL statement should you run?

A.

B.

C.

D.