Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The CUSTOMER table maintains information about each customer, such as their ID, first and last name, address, balance, and credit limit. CUSTOMER table In the

The CUSTOMER table maintains information about each customer, such as their ID, first and last name, address, balance, and credit limit.

CUSTOMER table

In the INVOICES table contains information about each invoice, such as the invoice number, date, and the customer being invoiced.

INVOICES table

The INVOICE_LINE table has the itemized information for each invoice. This includes the item ids, quantity, and price for each invoice.

INVOICE_LINE table

The ITEM table has a information pertaining to each item for sale by KimTay's Pet Supplies. This includes a description, the number in stock, location, and price.

ITEM table

The SALES_REP table includes the information for each sales representative for KimTay's Pet Supplies. This includes first and last name, address, cell-phone, commission, and commission rate.

SALES_REP table

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

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

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

step 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.

step 5: List the customer ID, the first name, and the last name of each customer represented by sales rep 10 or sales rep 15.

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

step 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.

step 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.

step 9: List the item ID, description, and on-hand value for each item where on-hand value is at least $1,500. Assign the name ON_HAND_VALUE to the computed column.

step 10: Use the IN operator to list the item ID and description of each item in category FSH or BRD.

step 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.

step 12: List all details about all items. Order the output by description.

step 13: List all details about all items. Order the output by item ID within location. (That is, order the output by location and then by item ID.)

step 14: How many customers have balances that are more than their credit limits?

step 15: Find the total of the balances for all customers represented by sales rep 10 with balances that are less than their credit limits

step 16: List the item ID, description, and on-hand value of each item whose number of units on hand is more than the average number of units on hand for all items.

step 17: What is the price of the least expensive item in the database?

1

stepimage text in transcribed18: What is the item ID, description, and price of the least expensive item in the database?

I desperately need help with this project.image text in transcribedEDIT I've posted this question before and now I'm reposting it. I've figured out the functions but for some reason my query still isent functioning my hypotheses to the terminology that should be use is " I believe that the dirictory isent functioning properly?"

-- Write your query below and then click "Run Qt execute it. To save multiple queries, click the icon above. SQL Viewer x> _ Terminal 1+ Run a SQL query to generate results 45 WHERE SALES_REP_ID =10 AND BALANCE (SELECT AVG(ON_HAND) FROM ITEM); 49 SELECT MIN(PRICE) 50 FROM ITEM; 51 SELECT item_id, description, price 52 FROM ITEM 53 ORDER BY price 54 LIMIT 1; > 4 ERROR 1054 (42S22) at line 2: Unknown column 'id' in 'fleld list

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions