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