Question: what is difference between simple view and complex view?
Answer: Simple View: A view based on only a single table, which doesn't contain GROUP BY clause and any functions. Complex View: A view based on multiple tables, which contain GROUP BY clause and functions.