7

These are queries that use the full Red Cit Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You mi 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. 7 What is the average list price for shoes? Your query should display one column named "Average List" (Hint: create an alias 'Average. Hit'). 21 select fron These are queries that use the full Red Cit Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You mi 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. 7 What is the average list price for shoes? Your query should display one column named "Average List" (Hint: create an alias 'Average. Hit'). 21 select fron