Answer to Question #16749 in Databases | SQL | Oracle | MS Access for Nikki
Create a view named BOOK_INVENTORY. It consists of the branch number and the total number of books on hand for each branch. Use Units as the name of the count of books on hand. Group and order the rows by branch number. Use the view to retrieve the branch number and units for each branch having more than 25 books on hand.
What is the SQL statement to gather the info after the View is created?
Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.