Workshop count list

Create a query to display the number of students who were enrolled in workshops in all sessions for 2014. The result should include the session, unit code, unit name, campus location, tutor name and the total count of students enrolled. The result should be sorted by the Session, unit code, campus location and workshop day & time.

B.6.3 Student Transcripts

Create a query to display the information required for a Student Transcript. The result should include the student number, student name, year, session, unit code, unit name and final grade. The result should be sorted by the students last name, first name, by year, session and then by unit code.

B.6.4 Student Assessment Totals

Create a query to display the total marks for each students assessments in all sessions for 2014. The result should include the student names, unit code, the sum of marks given for their assessments and the final grade given. It should be sorted by the students last name and first name, session, and unit code. Note: the final grade is entered by the unit assessor into the database, not calculated automatically from the total.