Database: planet_1
Question: What is the total shipments in each planet? List the planet name and total shipments.
SQL:
SELECT T2.Name ,  count(*) FROM Shipment AS T1 JOIN Planet AS T2 ON T1.Planet = T2.PlanetID GROUP BY T1.Planet;