Views
- Most queries involve current students.
- Rarely: queries involve all students, including graduated students.
Example
What are the names of current students majoring in Physics
select s.name
from all_student s join department d on (s.dept_id = d.dept_id)
where d.name = 'physics'
and s.graduation_date is null
|