Question: Need help with this sql question. Using attatched Redcat 2 database. These are queries that use the full Red Cat Database as shown in Figure

These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, Saleltem, Product, Manufacturef, and Employee tables. For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columins requested. Be sure that your queries do not produce duplicate records unless otherwise directed. There is not a limit to the number of times you may complete the assignment. Your grade will reflect your highest score. 3 Cive a unique alphabetical list of manufacturers from Indiana (state = IN) or Ohio (state * OH). Also include manufacturess from Calfornia (state - CA) when the city begins with D. Sort the list alphabetically (ascending by dity. Your report should show. manutacturer name, city, and atate. \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Customer } \\ \hline CustomertD or \\ \hline FirstName: \\ \hline LastName \\ \hline StreetAddress \\ \hline City \\ \hline State: \\ \hline PostalCode \\ \hline Country \\ \hline Phone \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Manufacturer } \\ ManufactureriD or \\ \hline ManufacturerName \\ \hline Address1 \\ \hline Address2 \\ \hline City \\ \hline State \\ \hline PostalCode \\ \hline Phone \\ \hline Fax \\ \hline Contact \\ \hline URL \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
