Queen Anne Curiosity Shop

M$.$ Write an SQL statement to list LastName, FirstName, and Phone of customers who have purchased an item that has an ItemPrice of $$500$ or more. Use a subquery.

N$.$ Answer part M but use a join using JOIN ON syntax. What are the consequences of using $($or not using$)$ the DISTINCT keyword in this version of the query?

O$.$ Write an SQL statement to list LastName, FirstName, and Phone of customers who have purchased an item that was supplied by a vendor with a CompanyName that begins with the letter L$.$ Use a subquery.

P$.$ Answer part O but use a join using JOIN ON syntax. What are the consequences of using $($or not using$)$ the DISTINCT keyword in this version of the query?