Formulate a single SQL query to produce the required information. In each case, display only the columns requested. Be sure queries do not produce duplicate records unless otherwise directed. A database schema is used: SIMPLIFIEDSALES SALEDATE FIRSTNAME LASTNAME PRODUCTNAME CATEGORY COLOR ITEMSIZE MANUFACTURER NAME PRICE. 1. List Products (Product Name) and their colors of shoes that are yellow or pink or orange. Use IN. Be sure to elliminate duplicate records. 2. Show sales information for sneakers whose color is not Black or Blue. 3. List Product name, Category, Manufacturere name, and price of shoes that have the word 'Leather' in the product name and which is priced at $100 or more. Be sure to eliminate duplicates. 4. Are there any sales where the sales clerk forgot to enter the shoe size? In other words where there is no data in the ItemSize field.