Hands-On AssignmentsTo determine the exact name of Felds used in the tables for these exercises, refer to the tablesin the JustLee Books database, or use the DESCRIBE tablename command to view the tablesstructure.1.Display a list of all data contained in the BOOKS table.Select *rom books;2.List the title only of all books available in inventory, using the BOOKS table.Select titlerom books;3. List the title and publication date for each book in the BOOKS table. Use the columnheading Publication Date for the Pubdate Feld.Select title, pubdate as Publication Daterom books;4. List the customer number for each customer in the CUSTOMERS table, along with the cityand state in which the customer lives.Select customer #, city, staterom customers;5. Create a list containing the publishers name, the person usually contacted, and thepublishers telephone number. Rename the contact column Contact Person in thedisplayed results. (Hint: Use the PUBLISHER table.)