Skip to content

Instantly share code, notes, and snippets.

@ibeauregard

ibeauregard/order-by.sql Secret

Created June 12, 2021 14:04
Show Gist options
  • Save ibeauregard/1681d67607a1799f6d349b043221903a to your computer and use it in GitHub Desktop.
Save ibeauregard/1681d67607a1799f6d349b043221903a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
order-by.sql
SELECT nameLast, nameFirst, yearID, HR
FROM players JOIN batting ON batting.playerID = players.ID
ORDER BY HR DESC, nameLast, nameFirst, yearID DESC;
Gonzalez|Luis|2001|57
Lopez|Javy|2003|43
Thomas|Frank|2000|43
Edmonds|Jim|2004|42
Edmonds|Jim|2000|42
Thomas|Frank|2003|42
Thomas|Frank|1993|41
Thomas|Frank|1996|40
Thomas|Frank|1995|40
Edmonds|Jim|2003|39
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment