- Class Cis225 Database Concepts 1 (159.15 KiB) Viewed 36 times
class: CIS225 database concepts
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
class: CIS225 database concepts
class: CIS225 database concepts
Use the Products table below for exercises 13 - 15 PRO_ID PRO_NAME 101 Mbt her Board 102 Keyboard 103 ZIP drive 104 Speaker 105 Monitor 106 DVD dri ve 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse PRO_PRI CE 3200.00 450.00 250.00 550.00 5000.00 900.00 800.00 2600.00 350.00 250.00 PRO COM 15 16 14 16 11 12 12 13 13 12 Source: https://www.w3resource.com/ 13. Write a T-SQL query to find all the products with a price between 300 and 1000. 14. Write a T-SQL query to list all products in alphabetical order using the name of each product. 15. Write a T-SQL query that groups all products on the commission class (PRO_COM) in ascending order.
Use the Products table below for exercises 13 - 15 PRO_ID PRO_NAME 101 Mbt her Board 102 Keyboard 103 ZIP drive 104 Speaker 105 Monitor 106 DVD dri ve 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse PRO_PRI CE 3200.00 450.00 250.00 550.00 5000.00 900.00 800.00 2600.00 350.00 250.00 PRO COM 15 16 14 16 11 12 12 13 13 12 Source: https://www.w3resource.com/ 13. Write a T-SQL query to find all the products with a price between 300 and 1000. 14. Write a T-SQL query to list all products in alphabetical order using the name of each product. 15. Write a T-SQL query that groups all products on the commission class (PRO_COM) in ascending order.