1. Write an SQL statement that does the following: For each row in the Stock table, if the TradingSymbol column is “XYZ”, change it to “ABC”. 2. Write an SQL statement that will delete rows in the...

1. Write an SQL statement that does the following: For each row in the Stock table, if the TradingSymbol column is “XYZ”, change it to “ABC”.

2. Write an SQL statement that will delete rows in the Stock table where the number of shares is less than 10.

3. Assume that the following declaration exists.

final String DB_URL 5 "jdbc:derby:CoffeeDB";

 The string referenced by DB_URL is a database URL. Write a statement that uses this string to get a connection to the database.