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

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

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

BOOK ld Title Publisher_name BOOK AUTHORS Book idAuthor name PUBLISHER Name Address Phone BOOK COPIES Book id Branch id No of copies BOOK LOANS Book id Branch id Card no Date out Due date LIBRARY BRANCH ld Branch name Address BORROWER Name Address Phone