Closed. This question needs details or clarity . It is not currently accepting answers.
Want to improve this question? Add details and clarify the problem by editing this post .
Closed 2 days ago.
Improve this question
I just need to figure out how to count the number of buildings each manager manages. I think I just need help for the syntax.
-- 5.2.10 Display the MFName, MLName, MSalary, MBdate, and number of buildings that the manager manages for all managers with a salary less than $55,000
Select MFName, MLName, MSalary, MBDate,
COUNT(BuildingID) as NoOfBuildManaged
From Manager, Building
Where Manager.ManagerID = Building.BManagerID
AND MSalary < 55000
Group By ManagerID;
1条答案
按热度按时间ie3xauqp1#