Database: planet_1
Question: How many shipments take place on each planet?
SQL:
SELECT T2.Name ,  count(*) FROM Shipment AS T1 JOIN Planet AS T2 ON T1.Planet = T2.PlanetID GROUP BY T1.Planet;