question 3,4,5,6,7 please

the one posted ok chegg isnt working

please answr new one

Henry Books Case II 1. Create a view named Penguin Books. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a view named Paperback. It consists of the book code, book title, publisher name, and book price for every book that is available in paperback. Display the data in the view. 3. Create a view named Book Inventory. It consists of the book code and the total number of units of the book on hand at any branch. Display the data in the view. 4. Create the following indexes. If it is necessary to name the index in your DB