The database is really big so I can you send me the email of the tutor so I could send the database please:

Please help

1. Product sales: 1a: Develop stored Procedure or user defined function that will accept product id, date and will return gross daily sales, gross return sales, gross net sales for that product. 1b: Develop stored Procedure that will accept product id, month, year and will return gross monthly sales, gross monthly return sales, gross net monthly sales for that product.. 1c: Develop stored Procedure that will accept product id, year and will return gross yearly sales, gross yearly return sales, gross net yearly sales for that product.

2. Customer sales: 2a: Develop stored Procedure or user defined function that will accept customer id, date and will return gross daily sales, gross return sales, gross net sales for that customer. 2b: Develop stored Procedure that will accept product id, month, year and will return gross monthly sales, gross monthly return sales, gross net monthly sales for that customer.. 2c: Develop stored Procedure that will accept product id, year and will return gross yearly sales, gross yearly return sales, gross net yearly sales for that customer.

3. Employee sales: 3a: Develop stored Procedure or user defined function that will accept employee id, date and will return gross daily sales, gross return sales, gross net sales for that customer. 3b: Develop stored Procedure that will accept employee id, month, year and will return gross monthly sales, gross monthly return sales, gross net monthly sales for that customer.. 3c: Develop stored Procedure that will accept employee id, year and will return gross yearly sales, gross yearly return sales, gross net yearly sales for that customer.

4. State sales: 4a: Develop stored Procedure or user defined function that will accept state abbreviation, date and will return gross daily sales, gross return sales, gross net sales for that customer. 4b: Develop stored Procedure that will accept state abbreviation,, month, year and will return gross monthly sales, gross monthly return sales, gross net monthly sales for that customer.. 4c: Develop stored Procedure or user defined function that will accept state abbreviation, year and will return gross yearly sales, gross yearly return sales, gross net yearly sales for that customer.

**************************************************************************

Using OES2 database, Create the following triggers and update the order table 1. To calculate the total gross sale for each order and update the order table 2. To calculate the total shipping charge (see the shipping rates below) for each order and update the order table 3. To calculate the total tax charge for each order (see tax table) and update the order table

Shipping rates Ground 5% of gross order amount 1 Day or 1 Day-air 15% of gross order amount 2 Day or 2 Day-air 10% of gross order amount

Note:

"orders" table in OES2 has some missing data. For example, subtotals, some of tax_amt, some of shipping_charge, and all total_amt are missing appropriate data.