Question: Please provide two screenshots 1 . List the item ID , description, and price for all items. 2 . List all rows and columns for
Please provide two screenshots
List the item ID description, and price for all items.
List all rows and columns for the complete INVOICES table.
List the first and last names of customers with credit limits of $ or more List the order number for each order placed by customer number on Hint: If youneed help, use the discussion of the DATE data type in Figure in Module
List the number and name of each customer represented by sales rep or sales rep
List the item ID and description of each item that is not in category HOR.
List the item ID description, and number of units on hand for each item that has between and units on hand, including both and
List the item ID description, and onhand value units on hand unit price of each item in categoryCAT. Onhand value is technically units on hand cost but there is no COST column in the ITEMtable. Assign the name ONHANDVALUE to the computed column.
List the item ID description, and onhand value for each item where onhand value is at least$ Assign the name ONHANDVALUE to the computed column.
Use the IN operator to list the item ID and description of each item in category FSH or BRD
Find the ID first name, and last name of each customer whose first name begins with the letter S
List all details about all items. Order the output by description.
List all details about all items. Order the output by item ID within location. That is order the outputby location and then by item ID
How many customers have balances that are more than their credit limits
Find the total of the balances for all customers represented by sales rep with balances that areless than their credit limits
List the item ID description, and onhand value of each item whose number of units on hand ismore than the average number of units on hand for all items. Hint: Use a subquery.
What is the price of the least expensive item in the database?
What is the item ID description, and price of the least expensive item in the database? Hint: Use asubquery.
List the sum of the balances of all customers for each sales rep. Order and group the results by salesrep ID
List the sum of the balances of all customers for each sales rep but restrict the output to those salesreps for which the sum is more than $ Order the results by sales rep ID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
