THIS IS FOR SQL! THANKS!

You are given two tables: Customer: A List of Customers. Contains Name and CustomerlD fields. (The CustomerID field can be used for a join) ScheduledPurchase: A list of Scheduled purchases. Contains CustomerID, PurchaseDate, and a bit field to indicate if the purchase was completed (IsPurchaseCompleted) Write SQL to give a list of all Customers, and indicate the Purchase date *IF* the purchase was completed. If a purchase was never scheduled or never completed, list the Customer without any purchase date. Expected output columns: CustomerID, CustomerName, PurchaseDate