Sep 15, 2020	COP-4710	Due: Thu, Sep 24 before 11:50pm
	Assignment-3

The purpose of this assignment is to master the design of stored procedures. Use Premiere Products database in XAMPP.

Create a user defined stored procedure (uspGetRepStats) on the Premiere Products database that would accept a Rep number (char 2) and then generates the following statistics only if the given rep number exists:

The firstname and the lastname of the rep.
The number of customers associated with this rep.
The total balance of all these customers.
The number of orders placed by all these customers.
The total revenue of the orders placed by all these customers.

Reference:
Sample stored procedures: uspGetEmpSalary, uspEmpHours, and uspEmpDependents
See text version of these files at C:\xampp\htdocs\course\scripts\company\storedproc
for the Company database with schema, snapshot, and description
For the PremiereProducts database, refer to the schema and snapshot

Upload the stored procedure file (uspGetRepStats.sql) through Canvas along with the following declaration:

     ========================================================

     Name: _________________________

     Panther-ID: x x x -_______

     Course: COP 4710 

     Assignment#: 3

     Due: Thu, Sep 24, 2020

     I hereby certify that this work is my own and none of
     it is the work of any other person.

                             Signature: ______________________
     =========================================================