Question 2 marks] Based on the below database schema, write the following Select statements Book: (Book ID, title, pub_i

[answerhappygod]

Question 2
marks]
Based on the below database schema, write the following Select statements
Book: (Book ID, title, pub_id, author _ID)
Author: (Author ID, name, city, phone_num)
Publisher: (Pub id, name, city, phone_num)
The schema is assuming that each book has only one author and one publisher while the
author and publisher produce many books. (a book has 1-to-many relationship with both
author and publisher).
1. List all book titles that contain "Information".
2. List all publisher count and city grouped by their city and the city should have at least 2
publishers.
3. List book title, author name, and publisher name sorted by book title.
4. List all publisher names who do not have books in the database.
5. List book titles which are authored by 'Ibrahim Youssef'.
6. List all author names with their city and their phone numbers.
7. List all author names and publisher names which are located in the same city.