1) computer claims this is incorrect

These are queries that use the full Red Cat Datalbase 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, Manufacturer, 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 columns requested. 1 Which manufactures are located in the state of Missouri (Missouri - MO)? Show the manufacture name, city, state, and postal code. A. select stote, nanufocturernase, city, postal code fron nonufocturer inner join city on nanufocturerid-city. cityid where state- ' 10