Assuming that you have a database, which contains a table, called books. Assume that the books table was created with the DDL create statement below and contains the values listed in the following table. Develop a SQL update statement that will change the cost column of each row in the table, which has a publication date before 10/01/2009 to a value of $0.00. Post your solution to the discussion forum and compare with the solutions of your peers. Discuss different approaches to solving this problem.

create table books( Bookld Sequence Title Author ISBN Pub_Date Cost integer, integer, char(30), char(30), char(20), date, decimal(10,2) Bookld Sequence Title Author ISBN Pub_Date Cost Lewis Carroll 1441435840 5/1/1997 7.95 Alice in Wonderland effrey Ullman 978- 0136006374 10/6/2007 $99.49 A First Course in Database Systems (3'd ed Abraham 978- 01/27/2010 $119.67 Database System Concepts Silberschatz 0073523323 Grimm's Jacob Grimm 1414291477 02/01/2004 $26.99 Fairy Tales 1448625025 12/01/2010 $7.95 A Tale of Two Charles Cities Dickens War and Leo Tolstoy 978 09/01/2007 $7.99 Peace 1853260629 10/01/2009 $7.95 The Scarlet letter Pride and Prejudice Nat Nathaniel Hawthorne 1904633129 Jane Austen 978 978- 09/20/2004 $7.95 1593083243