I need help with this SQL I keep getting error the information is not found.

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, Manufactures, and Employee tables. Eor each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed. 1 Select city 2 fron manufacturer m, product p 3 anere m.Manufactureid=p. ManufacturerID andegory='Boots'; ReCOrd CoUnt: 0 Select city from manufacturer m, product p where m.ManufactureID=p.ManufacturerID and p.category='Boots' Who are the customers (first and last names) that bought "casual shoes" from the manufacturer named Timberland? (Note category names are lower case, manufacturer names are capitalized in the database.) Record Count: 0 Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomerID inner join Sale Item on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where category = 'Casual shoes' and Manufacturer Name = 'TIMBERLAND' Error ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near Name'. Select ProductName, ListPrice from Product inner join Sale Item on Product.ProductiD = SaleItem.ProductID inner join Sale on SaleItem.SaleID = Sale.SaleID where Sale Date = '14-FEB-2014' Error ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near Date'. What are the names of products from manufacturers in Washington state? 1 Select product Name 2 fron Product 3 inner join Manufacturer 4 on Product.ManufactureriD = Manufacturer.ManufacturerID 5 where State = "Washington"; Record Count: 0 Select Product Name from Product inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where State = 'Washington' ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Product'. What are the names of customers who have bought products with a current list price of over $60 made by manufacturers in New Jersey? Show first and last names. Record Count: 0 Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomerID inner join Sale Item on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where ListPrice >60 and State = 'New Jersey' Error ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Last'. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "SaleItem.SaleID" could not be bound. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "SaleItem.ProductID" could not be bound. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'State'. Who are the customers from Illinois who have bought products with a list price of over $100 or who have bought flats? Show first and last name only. Record Count: 0 Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomeriD inner join SaleItem on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where ListPrice >100 or Category = 'flats' and State = 'Illinois' Error ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Last'. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'State'. What is the weekly pay of wage employees? Weekly pay is defiend as the Wage times the MaxHours. Show three columns: FirstName, LastName and WeeklyPay. Sort the resutls by WeeklyPay in descending order 1 Select FirstName, Last Name, Wage*MaxHours as Weekly Pay from Employee inner join wage Employee on Employee. EmployeeID = WageEmployee . Employeerd order by Wage*Maxhours; Record Count: 0 Select FirstName, Last Name, Wage 'MaxHours as Weekly Pay from Employee inner join Wage Employee on Employee.EmployeeID = WageEmployee.EmployeeID order by Wage "MaxHours ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Pay'. List Hourly (wage) Employees (first and last names), their hire dates and then the full name (first and last) of their manager. (Rename manager name columns as MgrFirstN,MgrLastN.) Employee E2 on E1.ManagerID = E2. EmployeeID inner join Wage Employee on E1. EmployeeID = WageEmployee. EmployeeID; Record Count: 0 Select Wage,E1.FirstName ,E1.LastName ,E1.Hiredate ,E2.FirstName as MgrFirstN,E2.LastName as MgrLastN from Employee E1 inner join Employee E2 on E1.ManagerID = E2.EmployeeID inner join Wage Employee on E1.EmployeeID = WageEmployee.EmployeeID ERROR [42SO2] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Wage