Answered step by step
Verified Expert Solution
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?
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 companyStep 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