Microsoft Access 2003
Teacher = [CourseN, Quarter,TeacherName]
Course = [Course N Quarter , DayTime, Room #]/ Examples of DayTime: M 2:00,
W 4:50, and T 8:00.
Student = [studentName,Course #, Quarter]
^The underlined words are the primary keys
I want to be able to list the student name that took the most courses.. but I'm having trouble coming up with the correct syntax
FROM Student A
WHERE (SELECT COUNT(CourseN)
FROM Student B
WHERE COUNT(CourseN)) > ......something here
or If I wanted to list every course number and the student's name who has taken the same course twice... I have something like:
FROM Student AS A
GROUP BY A.studentName
but that's coming up wrong too..
any help would be appreciated, thanks