2.5: Update
Write a query that updates the Products table you made in Part 2.4.
Target a specific ProductID and change the ProductName. (The item in the third row should now be called The Flattest Flat Head)
Change the price of a single item. (The item in the first row should now cost 12.75)
Change the price of multiple items that have the same price. (The items in the third and fourth rows should now cost 3.50)
After making these updates, your table should reflect the changes below. The edited data is in red.
ProductID | ProductName | Price | ProductDescription |
1 | Clamp | 12.7500 | Workbench clamp |
2 | Clamp | 12.4800 | Workbench clamp |
50 | The Flattest Flat Head | 3.5000 | Flat head |
51 | Screwdriver | 3.5000 | Flat head |
52 | Screwdriver | 3.1700 | Flat head |
75 | Tire Bar | NULL | Tool for changing tires |
To see the solution for this challenge, click on 2.12 Solutions. Then, continue to Part 2.6: Read.
Last updated