Show me all films longer than 100 minutes?
select title from film where length > 100
Show me all the films not longer than 100 minutes?
select title from film where length < = 100
Find all the films rated PG, except those who cost more than 200 for replacement?
select title from film where rating = 'PG' except select title from film where replacement_cost > 200