Question
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
step18: What is the item ID, description, and price of the least expensive item in the database?
I desperately need help with this project.EDIT 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 listStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started