Question: Use SQL and TAL Distributors database to complete the following questions: 1- What is the price of the least expensive item in the database? 2-
Use SQL and TAL Distributors database to complete the following questions: 1- What is the price of the least expensive item in the database? 2- What is the item number, description, and price of the least expensive item in the database? (Hint: Use a subquery) 3- List the sum of the balances of all customers for each sales rep. Order and group the results by sales rep number. 4- List the sum of the balances of all customers for each sales rep, but restrict the output to those sales reps for which the sum is more than $5000. Order the results by sales rep number. 5- List the item number and description of all items that are in the PZL or TOY category and contain the word "Set" in the description. 6- TAL Distributors is considering discounting the price of all items by 10 percent. List the item number, description, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
