Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please create the following SQL Server queries that access the Northwind database. Place them in . txt format. Note: These problems all require aggregate processing
Please create the following SQL Server queries that access the Northwind database.Place them in txt format. Note: These problems all require aggregate processing with GROUP BY
For each employee, list the employee ID employee first name, employee last name, and count of orders taken in Place the list in descending order by the count of orders.
For all orders shipped in July or August, list the order ID company name, order date, and total cost of all items ordered. Place the list in descending order by the total cost.
For all customers from the USA, list the customer ID company name, state, count of orders, and total order amount. Do not consider the discount. Place the list in order by state and then customer ID but limit the list to all customers who placed or more orders.
For allitems in theGrainsCereals category, list the product ID product name, supplier name, and last date that the product was ordered. Order the list by supplier name and product name Hint: Use MAX and be sure to include all necessary tables
The product ID product name, and count of distinct customers who ordered that product in Place the list in descending order by the count of customers.
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