On bad student solution, remove group by and sum(), then show they the resultset ... you can discard every student that don't understand it
That's exactly what I wind up doing - discard the aggregations and let them see the raw details in the result set. When they see the raw data, some immediately see what's going on.