items Task 2 List all rows and columns for the complete

Last updated: 11/14/2023

items Task 2 List all rows and columns for the complete INVOICES table Task 3 List the first name last name and credit limit of customers with credit limits of 1 000 or more Task 4 List the invoice number for each order placed by customer number 125 on 2021 11 15 Task 5 List the customer ID the first name and the last name of each customer represented by sales rep 10 or sales rep 15 Task 6 List the item ID and description of each item that is not in category HOR Task 7 List the item ID description and number of units on hand for each item that has between 10 and 30 units on hand including both 10 and 30 Task 8 List the item ID description and on hand value units on hand unit price of each item in category CAT On hand value is technically units on hand cost but there is no COST column in the ITEM table Assign the name ON HAND VALUE to the computed column Database Model Kim Tay The management of Kim Tay Pet Supplies a supplier of pet supplies food and accessories located in Cody Wyoming has determined that the company s recent growth no longer makes it feasible to maintain customer invoice and inventory data using its manual systems In addition KimTay Pet Supplies wants to build an Internet presence With the data stored in a database