Student Name: student ID: Consider a library database with the following tables: n.L1:-1.A. TAL1A A. Please write down the proper SQL statements to do the followings: 1. Create the above two tables with proper data types, and primary and foreign keys. 2. Return the number of books published by each publisher. 3. Find the price of the book "Database Systems". 4. Find all information of publishers located in USA 5. Find the publisher name for each book