Question: I am having troubles with the sql Quieries using both join and group funcitions for the following quieries. A list of customer names with the

I am having troubles with the sql Quieries using both join and group funcitions for the following quieries. A list of customer names with the number of orders that have ordered. A list of all

I am having troubles with the sql Quieries using both join and group funcitions for the following quieries.

A list of customer names with the number of orders that have ordered.

A list of all customers that have ordered a product within the last 30 days.

A list of customer name, order date, and product name ordered by the customer name.

A list of product name and the category name that they belong to.

A list of each product and the total amount that they have sold for along with their average number of units sold. Include products that have been sold.

A list of states with the number of units that have been sold to that state.

A list of month, year, and average order total for each month.

A list of mailing addresses that have at least 5 orders.

A list of the most popular products sold (consider quantity) with the number of items they have sold.

A list of product names that belong to the same category as the most popular product.

The table names are listed in the photo along with the fields withhin them.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please provide the SQL statement and the number of records returned Using the Northwind Database, please provide the following information. List all fields and all customer records. List all fields...

This is a group assignment with a maximum of 3-4 students per growp, Assessment Value =20% for your total marks for this subject Due date/ time: Please see Canvas, This case study project requires...

Use the database created using orderprocessing.sql Download orderprocessing.sqland create SQL statements for the following. 1 . Display a list of customer names who's orders have shipped one day...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

need question 1-9 and question 13 done Chapter 9 Advanced Query Formulation with SQL 367 2017 2. Using a Type Il nested query, list the customer number, name (first and last), and city of each...

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

Explain why companies might declare a stock dividend rather than a cash dividend.

Super Dolls is a toy manufacturing company which is in the business for the past two decades. The manufacturing unit is situated in Mumbai, while its sales and marketing are spread over a large...

substantive audit procedures for trade debtors using computer assisted audit techniques ( CAATs )

Give correct answer kudos! Thank you! D Question 16 4.5 pts You launch your new venture with a 0 cash opening balance and expect negative operating cash of -($10,000) and negative investment cash of...

=+countries or between companies and their unions in multiple countries?

=+ Is recognition of a union an entitlement or not? Level of organization

=+ Are unions company-wide, regional, or national?