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.