How many salaried employees are there and what is their averagesalary? Name the columns Num Of Salaried and AvgSalary. Round theAvgSalary to 2 decimal places.
4.3o Aggregate Queries 2 (no grouping)
These are queries that use the full Red Cat Database as shown inFigure 3.1. To do these queries you cannot use the SimplifiedSalesdatabase. You must use the full Red Cat tables of Customer, Sale,SaleItem, Product, Manufacturer, and Employee tables.
For each information request below, formulate a single SQL queryto produce the required information. In eachcase, you should display only the columns requested. Be sure thatyour queries do not produce duplicate records unless otherwisedirected.