Skip to content

Instantly share code, notes, and snippets.

@pamelafox
Created November 22, 2021 21:11
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save pamelafox/f6cd534b5042923e2d8463a485663eb0 to your computer and use it in GitHub Desktop.
Animals SQL
CREATE TABLE animals (name TEXT, legs INTEGER, weight INTEGER);
INSERT INTO animals VALUES ("dog", 4, 20);
INSERT INTO animals VALUES ("cat", 4, 10);
INSERT INTO animals VALUES ("ferret", 4, 10);
INSERT INTO animals VALUES ("parrot", 2, 6);
INSERT INTO animals VALUES ("penguin", 2, 10);
INSERT INTO animals VALUES ("t-rex", 2, 12000);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment