Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Databases questions

Question

Are the following statements true or false? K , 5 is planar

Answered: 1 week ago