What are the types of the ships that have both shiips with tonnage more than 6000 and those with tonnage less than 4000?
select type from ship where tonnage > 6000 intersect select type from ship where tonnage < 4000