Let's imagine that you are maintaining a database of a certain university. The dean wants to give an increased scholarship to senior students. Create a view with the names and surnames of such students.
Your view senior_students should select data from the table students with the value of the course > 2 and contain only two columns: name and surname.