Advertisement
Guest User

Untitled

a guest
Jan 20th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. SELECT Advisors.FirstName,Advisors.LastName,Count(Student.StudentID)
  2. As StudentCount
  3. FROM Advisors.AdvisorID=Student.AdvisorID
  4. Group By Advisors.LastName,Advisor.Firstname
  5. Having Count(Student.StudentID)<=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement