For each type, what is the average tonnage?
select type, avg(tonnage) from ship group by type