This only return one record. Is there a way to get a record for each student with one query?

Also, there's only one table involved in the query.

Thanks

Blue