Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Advisors.FirstName,Advisors.LastName,Count(Student.StudentID)
- As StudentCount
- FROM Advisors.AdvisorID=Student.AdvisorID
- Group By Advisors.LastName,Advisor.Firstname
- Having Count(Student.StudentID)<=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement