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:

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!