Name Surname:

Book Store Database

Write the SQL queries on Book Store Database according to the statements below.

Display the customers whose last names contain $\text{'}e\text{'}.$

Display all the books with publisher title, whose price is more than $100.$

Display all the authors with firstname and lastname and the number of their books.

Display all the publishers with title and their books, order the list according to title of the publishers.

Display book title, customer first and last names, author fist and last names and total price for each order.