Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.