lab 4-1 datavisulization

Task 1: List the item ID, description, and price for all items.

1

Task 2: List all rows and columns for the complete INVOICES table.

1

Task 3: List the first name, last name, and credit limit of customers with credit limits of $1,000 or more.

1

Task 4: List the invoice number for each order placed by customer number 125 on 2021-11-15.

If you need help, use the discussion of the DATE data type in Figure 3-16 in Module 3.

1

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.

1

Task 6: List the item ID and description of each item that is not in category HOR.

1

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.

1

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.