Skip to content

Instantly share code, notes, and snippets.

@pamelafox

pamelafox/playerscores.sql

Created May 16, 2018 20:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pamelafox/68532e1593187eaa0014c8870d0508de to your computer and use it in GitHub Desktop.
Save pamelafox/68532e1593187eaa0014c8870d0508de to your computer and use it in GitHub Desktop.
Download ZIP
playerscores.sql
Raw
playerscores.sql
CREATE TABLE IF NOT EXISTS playerscores (player TEXT, score INTEGER);
INSERT INTO playerscores VALUES ("Miss P", 34);
INSERT INTO playerscores VALUES ("Mr H", 99);
INSERT INTO playerscores VALUES ("Miss Piggy", 10);
SELECT * FROM playerscores ORDER BY score DESC LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment