EXPLAIN
A more interesting query
Query 13 from Assignment 5:
select m.message_date
from member f join routing r on f.member_id = r.from_member_id
join message m on r.message_id = m.message_id
where f.name = 'Unguiferous'
intersect
select m.message_date
from member f join routing r on f.member_id = r.from_member_id
join message m on r.message_id = m.message_id
where f.name = 'Abderian'
order by message_date;
|