[Solved]-Question 4 10 Points Retirement Benefits Sales Bonus Employees 60 Years Older Change Due C Q37298118
Question 4 (10 points) The retirement benefits and sales bonus for employees, who are 60 years or older, will change due to changes in policies by the Human Resources department. The HR manager wants a list of all those employees (60 years and above) and the total number of sales for each employee, (above 60 years) from the orders table. The table should list last name and the Number of Sales as illustrated below (Use employees and orders tables) Last Name Number of Sales Buchanan 42 Callahan 104 Question 5 (10 points) The Shippers table lists three shippers, Speedy Express, United Package, and Federal Shipping. In the orders table, the Shipvia and freight are the shipper ID and the cost of shipping The Vice President of Sales, Dr. Fuller, wants a report to review the cost of shipping. A sample of column headings requested by the Vice President of Sales are shown below. Write a query to generate the output requested by Dr Fuller with column headings as listed below (use the orders and shippers’ tables) Shippers Federal Shipping 80.4412 Average Shipping Cost Total Shipping Cost 20512.51 Number of Orders 255 Orders Employees EmployeelD 9 OrderlD LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Photo Notes Reports To PhotoPath Shippers 9 ShipperD CompanyName Phone Show transcribed image text Question 4 (10 points) The retirement benefits and sales bonus for employees, who are 60 years or older, will change due to changes in policies by the Human Resources department. The HR manager wants a list of all those employees (60 years and above) and the total number of sales for each employee, (above 60 years) from the orders table. The table should list last name and the Number of Sales as illustrated below (Use employees and orders tables) Last Name Number of Sales Buchanan 42 Callahan 104 Question 5 (10 points) The Shippers table lists three shippers, Speedy Express, United Package, and Federal Shipping. In the orders table, the Shipvia and freight are the shipper ID and the cost of shipping The Vice President of Sales, Dr. Fuller, wants a report to review the cost of shipping. A sample of column headings requested by the Vice President of Sales are shown below. Write a query to generate the output requested by Dr Fuller with column headings as listed below (use the orders and shippers’ tables) Shippers Federal Shipping 80.4412 Average Shipping Cost Total Shipping Cost 20512.51 Number of Orders 255
Orders Employees EmployeelD 9 OrderlD LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Photo Notes Reports To PhotoPath Shippers 9 ShipperD CompanyName Phone
Expert Answer
Answer to Question 4 (10 points) The retirement benefits and sales bonus for employees, who are 60 years or older, will change due… . . .
OR
