Consider the following schema

 Members (Member_id, name, Designation, Age)
 Books (Bid, Btitle, Bauthor, Bpublisher, Bprice)
 Reserves (Member_id, Bid, date)

Create the tables along with necessary constraints and insert values appropriately.

Write the following queries in SQL:

1. Find the ID’s of members who have not reserved books that cost more than Rs 500.
2. List the titles of books reserved by Professors in alphabetical order.
3. Find the names of members who reserved all the books.
4. Create a view that displays Member_id, number of books reserved by each member.

Note:[ Please update an answer before 12:00 A.M. (-_-) ]