All you showed was the SELECT column list. Could you please provide the full query based on the test table I provided in an earlier post? I would like to see how you would get the grouping of the subject IDs for a particular student.
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato