Remaining questions on SQL Henry Books database:

**********************************************************************************

Henry is considering increasing the price of his books in "Excellent" condition by 10%. Prepare a query that will show him the book code, book title, the current price and the price increased by 10%. Avoid displaying duplicate rows.

**********************************************************************************

Write a query that will display the book title, author first name and author last name for all books in the Henrys on the Hill branch that are in Excellent condition. Be sure to list only one entry per book title.

**********************************************************************************

Write the SQL query you would run to delete entries with poor-quality books from the COPY table.

**********************************************************************************

What SQL query would you run to remove all of the data from the BOOK table but keep the table structure?

**********************************************************************************

Write the SQL statement that will create a new table that is a copy of the table BOOK (table structure with the same data) that will be called BOOK2?

**********************************************************************************

Write the SQL statement that will add a new column to BOOK2 called ISBN for ISBN numbers.

**********************************************************************************

Henrys wants entries for this new column but will not require them.

**********************************************************************************

Write the SQL script that will remove all of the tables from the Henry Books database in the correct order.

**********************************************************************************

Please answer all questions!!! Thank you <3

**********************************************************************************