Please Write down the SQL Queries based on above ER diagram

1. List all the branches with No of employees in range of 10 and 15

2. Find all publishers with t in their name

3. Find all books with Databases in their title

4. List the authors who published Higher Creativity

5. List the books of the publishers who located at NY

6. List all books with their authors (full name)

7. What is the max and min units on hand out of all books

8. List the publications of author Christie Agatha

9. List the book code and title of every book that has the type FIC or that has the publisher code BB.

10. Calculate the average price for each type of book.

11. For every book published by Addison Wesley, list the book title and book price.

12. Members get a 10% discount off regular book prices. To determine the discounted prices, calculate the dis-counted price of every book. (It can be calculate 90% of the current price, or calculate the difference of the current price and 10% of current price.)

book bookcode CHAR(4) book te VARCHAR(100) l publisher publisher code CHAR(2) publisher_name VARCHAR(30) publisher_city VARCHAR(30) publisher state VARCHAR(3) branch branch_no INT (11) branch_name VARCHAR (50) branch locaton VARCHAR(50) no employees INT(11) publisher-code CHAR(2) book type CHAR(3) book_price DECIMAL (5,2) paperback CHAR(1) publish_date DATETIME Indexes Indexes wrote Book code CHAR (4) invent ? bookcode CHAR(4) branch_no INT (11) units on hand INT (11) Author number CHAR(2) Sequence number INT (11) author author_no CHAR(2) last VARCHAR(60) first VARCHAR(60) Indexes Indexes