SHARE
TWEET

Untitled

a guest Jan 20th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top