Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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-

image text in transcribed
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

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

More Books

Students also viewed these Databases questions