SELECT Students.sProgram, Count(Students.sStudent) AS CountOfsStudent
FROM Students INNER JOIN Data ON Students.sStudent = Data.dStudent
GROUP BY Students.sProgram;
SELECT Students.sProgram, Count(Students.sProgram) AS CountOfProgram
FROM Students
GROUP BY Students.sProgram;
I've been trying for an hour to get them into one query but I can't seem to make it work.
Our community of experts have been thoroughly vetted for their expertise and industry experience.