MySQL, to reverse SELECT GROUP BY

I have checked the posts with the similar question (1, 2, 3 ...) but no solution works for me on MySQL57 (mysql-installer-community-5.7.13.0.msi). What I want to do is do "group by" in reverse direction (from bottom of the table going up). Really don't understand why following query doesn't work.