Tell me the publishers that have publications with price higher than 10000000.
select publisher from publication where price > 10000000
Tell me the publishers that have publications with price lower than 5000000.
select publisher from publication where price < 5000000
Okay. Show me the people in both lists.
select publisher from publication where price > 10000000 intersect select publisher from publication where price < 5000000