posted 8 years ago
I am doing a query to find the total number of staff at each football stadium and their managers. So far I am able to output the total number of staff for each stadium, however i need to show the manager as well for each stadium. Can someone help me on this, as i don't know how to include the manager. The manager is in a table called stadium under column "manager_no".
My code: