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.