|< < 7 > >|

Views

A view is not stored as a set of rows

Internally, the view is stored unevaluated.

A view can be arbitrarily complicated

Create a view to give the count of current students by major.
create view students_by_major as select d.name, count(*) from student s join department d on (s.major_dept_id = d.dept_id) group by d.name

|< < 7 > >|