Database: planet_1
Question: What are the number of shipments managed and names of each manager?
SQL:
SELECT T2.Name ,  count(*) FROM Shipment AS T1 JOIN Employee AS T2 ON T1.Manager = T2.EmployeeID GROUP BY T1.Manager;