SQL select command:

kaikaixinxiny 2012-05-22 02:36:20

9. List the part number, part description, and on-hand value for each part whose on-hand value is at least $7,500. Assign the name ON_HAND VALUE to the computation.
18. What is the part number, description,and price of the most expensive part in the database? (Hint: Use a subquery.)

19. List the sum of the balances of all customers for each sales rep. Order and group the results by sales rep number.

20. List the sum of the balances of all customers for each sales rep, but restrict the output to those sales reps for whom the sum is more than $10,000.

21. List the part number of any part with an unknown description.

...全文

162 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

kaikaixinxiny 2012-06-29

打赏
举报

9.SQL select command: select PartNum,Description ,OnHand from part where Price<=7500
19.SQL select command: select sum(Balance),RepNum from customer group by RepNum order by RepNum
20.SQL select command: select sum(Balance) from customer group by RepNum,Balance having sum(Balance)>10000
21.SQL select command: select PartNum from part where description is null

kaikaixinxiny 2012-05-24