Show the types of ships that have both ships with tonnage larger than 6000 and ships with tonnage smaller than 4000.
select type from ship where tonnage > 6000 intersect select type from ship where tonnage < 4000
Show the types of ships with tonnage between 3000 and 5000.
select distinct type from ship where tonnage > 3000 and tonnage<5000
What is the nationality of the ship with maximum tonnage?
select nationality from ship order by tonnage desc limit 1
Can you give me the nationality of the ship with minimum tonnage.
select nationality from ship order by tonnage limit 1
What is the maximum and the minimum tonnage for a cargo ship?
select max ( tonnage ) ,min ( tonnage ) from ship where type = 'Cargo ship'
Hmmm. Can you also give me the maximum and the minimum tonnage for a battle ship?
select max ( tonnage ) ,min ( tonnage ) from ship where type = 'Battle ship'