Please help with both!! Cant get ut rught!

List all the luly sales of white sneakers made by Nike. The report needs to show all current and future attributes for the Sales Item table plus the SaleDate. Give a unique alphabetical list of manufacturers from Indiana (state =IN ) or Ohio(stateOH). Also include manufacturers from California (state - CA) when the city begins with D. Sort the list alphabetically (ascending) by city. Your report should show manufacturer name, city, and state. 1 Select ManufocturerNane, City, State