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