Campus Manager Report Queries

NonAlumni.sql

SELECT idn, first_name, last_name, email, phone, COUNT(users.email) as courses
FROM users
INNER JOIN registrations ON users.id = registrations.user_id
GROUP BY users.email
HAVING COUNT(users.email) < 3 AND COUNT(users.email) > 1
ORDER BY courses DESC, cast(idn as Number) ASC;

SanAntonioStudents.sql

SELECT idn, first_name, last_name, email, phone, city
FROM users
JOIN registrations ON users.id = registrations.user_id
JOIN courses ON registrations.course_id = courses.id
JOIN terms ON terms.id = courses.term_id
JOIN locations ON term.location_id = locations.id
GROUP BY users.email;