Since this seems like a homework I won't be including the full statement to the answer. However to get you started:
First you need all dates. If you can rely on a fact that at least one student has attended on each day then you could use the attendance table to create the dates. For example
SELECT DISTINCT Date FROM Attendance
This will give you a result set containing all the necessary dates which you can use as an inline view in the statement. Since you're having the time in the field it may be necessary to eliminate it. For that you can
CAST[
^] the date column to date (instead of datetime).
Now you can use that previous result set and using for example correlated
NOT EXISTS[
^] to the attendance table you can include only those days when the given student wasn't present.
Submit an article or tip