Update student spec to catch more errors
Use subquery for absent

This should keep more of the finding in SQL with a subquery instead of
examining IDs in Ruby.