Question: Write a query to display month number, month name, and average sales amount for months with the average sales amount greater than average sales

Write a query to display month number, month name, and average sales amount for months with the average sales amount greater than average sales amount in 2017. Round the average amount to two decimal places. Sort the result by the month number. The query returns 5 rows. Include both the query and the result in your answer. See the output columns: Month Number Month Year Average Sales Amount 9. Write a query to display first names in EMPLOYEES that start with letter B but do not exist in CONTACTS. Sort the result by first name. The query returns 2 rows. Include both the query and the result in your answer. See the sample output. First Name 10. Write a query to calculate the values corresponding to each line and generate the following output including the calculated values. Include your query and the query result in your answer. The number of employees with total order amount over average order amount: ? The number of employees with total number of orders greater than 10: ? The number of employees with no order: ? The number of employees with orders: ?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
