SELECT * FROM production.products| product_id | product_name | brand_id | category_id | model_year | list_price |
|---|---|---|---|---|---|
| 1 | Trek 820 - 2016 | 9 | 6 | 2016 | 380 |
| 2 | Ritchey Timberwolf Frameset - 2016 | 5 | 6 | 2016 | 750 |
| 3 | Surly Wednesday Frameset - 2016 | 8 | 6 | 2016 | 1000 |
| 4 | Trek Fuel EX 8 29 - 2016 | 9 | 6 | 2016 | 2900 |
| 5 | Heller Shagamaw Frame - 2016 | 3 | 6 | 2016 | 1321 |
| 6 | Surly Ice Cream Truck Frameset - 2016 | 8 | 6 | 2016 | 470 |
| 7 | Trek Slash 8 27.5 - 2016 | 9 | 6 | 2016 | 4000 |
| 8 | Trek Remedy 29 Carbon Frameset - 2016 | 9 | 6 | 2016 | 1800 |
| 9 | Trek Conduit+ - 2016 | 9 | 5 | 2016 | 3000 |
| 10 | Surly Straggler - 2016 | 8 | 4 | 2016 | 1549 |