Question: what are the advantages of using view in sql?
Answer: Views can represent a subset of the data contained in a table. ... 
Views can join and simplify multiple tables into a single virtual table.
Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) ... 
Views can hide the complexity of data.