Problem:
SQL Views
Question 1: Describe the use of, and give the syntax for, a simple view.
Question 2: Describe the use of, and give the syntax for, a complex view.
Question 3: Describe the use of, and give the syntax for, a materialized view.
Please provide description of your answers.