Question
Query 1: Categories and Products We want a report that will list all the categories in our database and the total number of products we
Query 1: Categories and Products We want a report that will list all the categories in our database and the total number of products we have for each c ategory. Generate a report that will display the category ID , category name and the total number of products for each category . Note: There are an equal number of products under each category in our database.
Query 2 : Customer Loyalty 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.
Query 3 : Weekly Sales Report 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 .
Queries 4 and 5: User Generated Reports You have written three queries to meet the reporting needs of management. Now its 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 eCom merce 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. Report 1: 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. Report 2: This report must contain an advanced SQL function (aggregate or scalar). You may sele ct 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 full credit is using an advanced function and explaining the purpose of this query. Y ou 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
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