instruction: Show the types of ships that have both ships with tonnage larger than 6000 and ships with tonnage smaller than 4000.
response: SELECT type FROM ship WHERE tonnage > 6000 INTERSECT SELECT type FROM ship WHERE tonnage < 4000