SELECT
sa.schoolc sch#,
s.schname AS School,
Have_logged_In = COUNT(CASE WHEN u.logindate IS NOT NULL THEN 1 END),
Not_logged_In = COUNT(CASE WHEN u.logindate IS NULL THEN 1 END)
FROM
users AS u
INNER JOIN stugrp_active AS sa ON u.username = sa.suniq
INNER JOIN school AS s ON s.schoolc = sa.schoolc
WHERE
u.username like '3%'
AND sa.schoolc >= 300
GROUP BY
sa.schoolc,
s.schname
ORDER BY
sa.schoolc
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg