--task 9.1
SELECT 
	AccountManager, 
	COUNt (customerid) AS NrOfCustomers
FROM AccountManagers 
LEFT JOIN Customers USING (accountmanagerid)
WHERE customerclass = 'Top'
GROUP BY accountmanager
ORDER BY NrOfCustomers DESC;