Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started