Queen Anne Curiosity Shop

E$.$ Write an SQL statement to list ItemID and ItemDescription for all items that cost $$1000$ or more.

F$.$ Write an SQL statement to list ItemID and ItemDescription for all items that cost $$1000$ or more and were purchased from a vendor whose CompanyName starts with the letters New.

G$.$ Write an SQL statement to list LastName, FirstName, and Phone of the customer who made the purchase with SaleID $1.$ Use a subquery.

H$.$ Answer part G 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?