Chapter $1($A Guide to SQL$)$ Use the Kim Tay Pet Supplies database only.

All Case Exercises, pg$.12.$

KimTay Pet Supplies

Answer each of the following questions using the KimTay Pet Supplies data shown in Figure $1-2.$

No computer work is required.

$1.$ List the first and last names of all customers that have a credit limit above, but not includ$-$

ing, $$500.$

$2.$ List the invoice numbers for invoices placed by customer ID $435$ on November $18,2021.$

$3.$ List the item ID$,$ item description, and on$-$hand value for each item in category HOR.

$($Hint: On$-$hand value is the result of multiplying the number of units on hand by the price.$)$

$4.$ List the item ID and item description of all items that are in category DOG.

$5.$ How many customers have a balance that exceeds their credit limit$?$

$6.$ What is the item ID$,$ description, and price of the least expensive item in the database?

$7.$ For each invoice, list the invoice number, invoice date, customer ID$,$ and customer first and

last names.

$8.$ For each invoice placed on November $16,2021,$ list the invoice number, customer ID$,$ and

customer first and last names.

$9.$ List the sales rep ID$,$ and first and last names, for every sales rep who represents at least

one customer with a credit limit of $$1,000.$

$10.$ For each invoice placed on November $15,2021,$ list the invoice number, item ID$,$ item

description, and category for each item ordered.