View 1: Proposal for view to select book info and the store info it corresponds with as well as maximum cost from Book and Store Tables

View 1: Proposal for view to select book info and the store info it corresponds with as well as maximum cost from Book and Store Tables. CREATE VIEW BookStore AS SELECT Book.Isbn, Book.title, Book.author, max(Book.cost) as cost, CAST( Book.year AS date) AS Year, Store.Store_id AS Storeid, FROM Book INNER JOIN Store ON Book.store_id = store.store_id GROUP BY Book.cost; SELECT * FROM BookStore; DELETE VIEW BookStore; View 2: Proposal for view to find total stores and total books from Book and Store Tables. CREATE VIEW BookStore2 AS SELECT sum(Store.Store_id) AS TotalStore, sum(Book.Isbn) AS TotalBook, FROM Book INNER JOIN Store ON Book.Store_id = Store.Store_id GROUP BY Book.isbn, Store.Store_id; SELECT * FROM BookStore2