Queen Anne Curiosity Shop

I. Write an SQL statement to list LastName, FirstName, and Phone of the customers who made the purchases with SaleIDs $1,2,$ and $3.$ Use a subquery.

J$.$ Answer part I 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?

K$.$ Write an SQL statement to list LastName, FirstName, and Phone of customers who have made at least one purchase with SubTotal greater than $$500.$ Use a subquery.

L$.$ Answer part K 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?