Skip to main content

Activity 2.2D

1

Producing Reports

Using the solution to Activity 1.5, found in the previous section, develop a command file to create the student table and insert records into that table. Use SQL to display the entered rows.

Produce the following reports:

Report 1: details of students who have passed unit number 'U00313' or 'U00333' sorted by student number and unit number

Report 2: the student numbers and unit numbers of those students who failed to attend on 3 May 2004 sorted by student number within unit number

Check your answer

Next: Activity 2.2E