1. Question: What are the advantages of using view?
Views can be quite advantages for a number of reasons:
Maintainability: A view abstracts the gory details of a query.
Explanation: Not available