please help w/ queries 4&5 thx.

PROJECT TASK 7: DML AND REPORTING Overview of Project The class project will require students to apply the knowledge they learn in class in a practical manner. Each student 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 3) create stored procedures to develop the tables and insert the data 4) write SQL statements for data extraction and reporting. All work for this project MUST be done on your own. This is an individual assignment, not group assignment. Anybody caught copying the work of others will receive a zero for the project Project Task 7: Background Throughout the course of this semester you have analyzed the requirements for an eCommerce database, designed and developed your database. As a class we have gone through the process of writing the DDL scripts to create our database and the DML scripts to load the data. Now that we have a functional database loaded with data, we can start working with our database and performing business functions. Maintaining the data and reporting are two tasks that are performed daily on all databases. Data is constantly being inserted, updated and deleted. Managers need reports and users execute queries to look up inform ation. We will first take a look at some queries to get an understanding ho uced Then ou will write your own queries for reporting