Top Earners

  • + 4 comments
    ...
    GROUP BY 1
    ...
    

    means - group by first column from SELECT . The same pattern could be used for ORDER BY :

    ...
    ORDER BY 1
    ...
    

    order by earnings