a guest Jan 20th, 2019 63 Never
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;
RAW Paste Data