7A Find the order date for all the orders of customers who l

7.A. Find the order date for all the orders of customers who leave in Los Angeles using joins

B. Repeat the same query this time using non-correlated subqueries

Solution

7.

A. Join

Select O.orderDate from Orders O inner join Customers C on O.CustomerId = C.CustomerId where C.shippingAddress like \'%Los Angeles%\';

B. non-correlated subquery

Select orderDate from Orders where customerId IN(Select customerID from Customers where shippingAddress like \'%Los Angeles%\');

C. Where Exists

Select orderDate from Orders WHERE EXISTS (Select customerID from Customers where Orders.CustomerId = Customer.CustomerId and shippingAddress like \'%Los Angeles%\');