Sep 3, 2020	COP-4710	Due: Tue, Sep 15 before 11:50pm
	Assignment-2

The purpose of this assignment is to master the design of SQL retrieval queries Using HenryBooks and PremiereProducts databases in XAMPP.
For each of the following six queries, create one SQL query and test it on the appropriate database:

Henry Books database:

List the title of the book(s) whose price is greater than the price of all books of type 'FIC'. -- [q1.sql]
For each type of book, list the the book type, the number of books of that type, and the total number of OnHand value for all books of that type. -- [q2.sql]
List the name of authors who wrote any book of type 'MYS' and the book is available at the branch 'Henry Brentwood'. -- [q3.sql]

Premiere Products database:

List the customer name, balance, and credit limit of customers whose balance exceed half of their credit limit. -- [q4.sql]
List the name of customer(s) who has (have) the highest available credit. -- [q5.sql]
(available credit is obtained by subtracting the balance from the credit limit)
List the last name of each rep and the description of the part that was ordered by all customers associated with that rep. -- [q6.sql]

Compress all six query files (with adequate comments for each query) into a zip file (asg2.zip) and upload it through Canvas along with the following declaration:

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

     Name: _________________________

     Panther-ID: x x x -_______

     Course: COP 4710 

     Assignment#: 2

     Due: Tue, Sep 15, 2020

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

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