Avatar of Luke Pope
Luke Pope

asked on 

SQL Code help

Here is question. Here is SQL Im not getting it right.

SELECT a.AdvisorID, a.LastName, a.FirstName, COUNT( s.StudentID ) AS "COUNT(Students)"
FROM Advisors a
JOIN Students s
ON a.AdvisorID = s.AdvisorID
GROUP BY a.AdvisorID
HAVING COUNT(s.StudentID)='1';
Microsoft SQL Server

Avatar of undefined
Last Comment
Peter Chan

8/22/2022 - Mon