Page 1 of 1
e name: Froduct PROD_CODE PROD_DESCRIPT PROD_PRICE PROD_ON_HAND VEND_CODE 12.95 001278-AB Claw hammer 23 232 123-21UUY H
Posted: Fri Jun 10, 2022 11:58 am
by correctanswer
- E Name Froduct Prod Code Prod Descript Prod Price Prod On Hand Vend Code 12 95 001278 Ab Claw Hammer 23 232 123 21uuy H 1 (43.04 KiB) Viewed 92 times
e name: Froduct PROD_CODE PROD_DESCRIPT PROD_PRICE PROD_ON_HAND VEND_CODE 12.95 001278-AB Claw hammer 23 232 123-21UUY Houselite chain saw, 16-in. bar 189.99 235 18.63 231 GER-34256 Sledge hammer, 16-lb. head SRE-657UG Rat-tail file 2.99 15 232 ZZX/3245Q Steel tape, 12-ft. length 6.79 235 1. Write a simple query that will retrieve the product description and product price for all the rows in the table. 2. Write a simple query that will retrieve the product description, product on hand for all the rows with vendor code 232. 3. Write a simple query that will retrieve all the records in the table whose vendor code is not 231. Sort the results by product price in descending order.