SELECT TYPE ,  avg(Tonnage) FROM ship GROUP BY TYPE
Show different types of ships and the average tonnage of ships of each type.
SELECT TYPE , avg ( Tonnage ) FROM ship GROUP BY TYPE
select type , avg ( tonnage ) from ship group by type
Show different types of ships and the average tonnage of ships of each type .