B- Create the following queries using Data Manipulation Language (DML) student must be able to explain the queries.

i- Find the total number of feedback per book. Show book id, book title, and total number of feedback per book.

ii- Find the total number of feedback per member. Show member id, member name, and total number of feedback per member.

iii- Find the total number of book published by each publisher. Show publisher id, publisher name, and number of book published.

iv- Find the total number of book for each category. Show category id, category name, and number of book for each category.

v- From the book table, list the books where quantity is more than the average quantity of all books.

vi- Find the total number of books ordered by store manager from various publishers.

b) Create the following queries using Data Manipulation Language (DML) - student must be able to explain the queries. i. Find the total number of feedback per book. Show book id, book title, and total number of feedback per book. ii. Find the total number of feedback per member. Show member id, member name, and total number of feedback per member. iii. Find the total number of book published by each publisher. Show publisher id, publisher name, and number of book published. iv. Find the total number of book for each category. Show category id, category name, and number of book for each category. V. From the book table, list the books where quantity is more than the average quantity of all books. vi. Find the total number of books ordered by store manager from various publishers