SELECT TYPE ,  avg(Tonnage) FROM ship GROUP BY TYPE
For each type, what is the average tonnage?
SELECT TYPE , avg ( Tonnage ) FROM ship GROUP BY TYPE
select type , avg ( tonnage ) from ship group by type
For each type , what is the average tonnage ?