Database: planet_1
Question: Calculate total weight of package shipped in each planet . show the name of each planet .
SQL:
select t3.name ,  sum(t1.weight) from package as t1 join shipment as t2 on t1.shipment = t2.shipmentid join planet as t3 on t2.planet = t3.planetid group by t2.planet;