Insert Data: Write SQL statements to insert sample data into the tables.

SQL Queries: Write SQL queries to perform the following tasks:

Retrieve all books written by a specific author.

Get the order history for a specific customer.

Find all reviews for a specific book.

Retrieve the list of books along with their category names.

Get all orders with their shipping method and tracking number.

Update the cost of a specific shipping method ID$.$

Delete records of authors who do not have any books being sold in the online bookstore. Ensure that only those authors wit

no associated books in the inventory are removed from the authors table.