SELECT * FROM (
SELECT ps_customfields.getcf('Students',id,'short_name') short_name,
COUNT(*) AS num
FROM students
WHERE enroll_status = 0
AND ps_customfields.getcf('Students',id,'short_name') IS NOT NULL
GROUP BY ps_customfields.getcf('Students',id,'short_name')
) thelist
WHERE num > 1