Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me with this? Create a Microsoft Word document containing your SQL statements for each of the following reports and upload your

Can someone please help me with this?

image text in transcribed

Create a Microsoft Word document containing your SQL statements for each of the following reports and upload your document to UNM Learn. We want a report that will list all the categories in our database and the total number of products we have for each category. Generate a report that will display the category ID, category name and the total number of products for each category. We want a report that will let us know who our repeat customers are We want to be able to track customer loyalty and provide benefits to these customers who have made our company a success. Generate a report that will display the customer ID, their first and last name and the number of orders that each customer has placed on our website. The report should only show customers that have ordered from us more than once. We want a report that will show the total sales for the week of October 12^th, 2014. This report should include the total sales amount for each day from October 12^th to October 18^th. Generate a report that will display the date and total sales for each day for the week of October 12^th, 2014. You have written three queries to meet the reporting needs of management. Now it's your turn to create two reports of your own. You may write any SQL statement you wish based on what you have learned in the class. You should use the eCommerce tables developed in the group project to produce your reports Write a brief explanation of each query, what it is supposed to do and how it should be used by the users. Below are the minimum requirements for each report. This report must join two or more tables together. You may use an inner join our outer join. The number of attributes you select and the filtering criteria are up to you. The minimum requirement for full credit is using a join statement and explaining the purpose of this query. You must explain the results of the query and how these results can be used by someone within the company. This report must contain an advanced SQL function (aggregate or scalar). You may select results from a single table or join multiple tables together. The number of attributes you select and the filtering criteria are up to you The minimum requirement for fill credit is using an advanced function and explaining the purpose of this query. You must explain the results of the query and how these results can be used by someone with the company. Create a Microsoft Word document containing your SQL statements for each of the following reports and upload your document to UNM Learn. We want a report that will list all the categories in our database and the total number of products we have for each category. Generate a report that will display the category ID, category name and the total number of products for each category. We want a report that will let us know who our repeat customers are We want to be able to track customer loyalty and provide benefits to these customers who have made our company a success. Generate a report that will display the customer ID, their first and last name and the number of orders that each customer has placed on our website. The report should only show customers that have ordered from us more than once. We want a report that will show the total sales for the week of October 12^th, 2014. This report should include the total sales amount for each day from October 12^th to October 18^th. Generate a report that will display the date and total sales for each day for the week of October 12^th, 2014. You have written three queries to meet the reporting needs of management. Now it's your turn to create two reports of your own. You may write any SQL statement you wish based on what you have learned in the class. You should use the eCommerce tables developed in the group project to produce your reports Write a brief explanation of each query, what it is supposed to do and how it should be used by the users. Below are the minimum requirements for each report. This report must join two or more tables together. You may use an inner join our outer join. The number of attributes you select and the filtering criteria are up to you. The minimum requirement for full credit is using a join statement and explaining the purpose of this query. You must explain the results of the query and how these results can be used by someone within the company. This report must contain an advanced SQL function (aggregate or scalar). You may select results from a single table or join multiple tables together. The number of attributes you select and the filtering criteria are up to you The minimum requirement for fill credit is using an advanced function and explaining the purpose of this query. You must explain the results of the query and how these results can be used by someone with the company

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

Step: 3

blur-text-image

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

Marketing Database Analytics

Authors: Andrew D. Banasiewicz

1st Edition

0415657881, 978-0415657884

More Books

Students also viewed these Databases questions

Question

4. Who should be invited to attend?

Answered: 1 week ago