1.Write an SQL statement to retrieve the titles of all books by author 'Navathe'.

2.Write an SQL statement to retrieve the number of copies of 'Fundamentals of Database Systems'.

3.Write an SQL statement to retrieve all book titles borrowed by 'Anna Kim'.

4.Write an SQL statement to retrieve title and author of all books sorted by author in ascending order.

5.Write an SQL statement to insert a new book into the library database. Use your favorite book data.

6.Write an SQL statement to update misspelled book authors. You should replace 'Elamarsi' with 'Elmarsi'.

eQuestion I0 BOOK Time Running: Hide Attempt due: Nov 26 at 11:55p 1 Hour, 53 Minutes, 48 Se Id Title Publisher_name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book idBranch id No_of_copies BOOK LOANS Book id Branch idrdo Date_out Due_date LIBRARY BRANCH | Branch-name | Address BORROWER Number Name Address Phone