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
[{'Type': 'Battle ship', 'avg(Tonnage)': 4845.0}, {'Type': 'Cargo ship', 'avg(Tonnage)': 3932.2}]