Inswer each of the following questions using the KimTay Pet Supplies data shown in Figure 1-2. SALES_REP ITEM INVOICF I INE FIGURE 1-2 Sample data for KimTay Pet Supplies 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.) List the item ID and item description of all items that are in category DOG. How many customers have a balance that exceeds their credit limit? For each invoice, list the invoice number, invoice date, customer ID, and customer first and last names