Skip to content

Instantly share code, notes, and snippets.

@pamelafox
Created November 22, 2021 21:11
Show Gist options
  • Save pamelafox/f6cd534b5042923e2d8463a485663eb0 to your computer and use it in GitHub Desktop.
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