1. Question:What are the advantages of using view? 

    Views can be quite advantages for a number of reasons:
    Simplicity: Saving the hassle of repeatedly querying multiple tables to retrieve this information.
    Security: Quite certain some information is inaccessible to third parties, such as the SSNs and salaries of employees.
    Maintainability: A view abstracts the gory details of a query.

    1. Report