SQL - Convert the following sample database commands to "real" SQL

CREATE TABLE animals (name VARCHAR (20), kind VARCHAR(8), years INTEGER) PRIMARY KEY (name, kind); INSERT INTO animals VALUES FROM ("Spot", "dog", 10); INSERT INTO animals VALUES FROM ("Snoopy, "dog", 3); INSERT INTO animals VALUES FROM ("Tweety", "bird", 1) INSERT INTO animals VALUES FROM ("Joe" "bird", 2) SHOW animals; dogs 10) dogs; cats_or_dogs dogs (select (kind "cat) animals); CREATE TABLE species (kind VARCHAR (10)) PRIMARY KEY (kind); INSERT INTO species VALUES FROM RELATION project (kind) animals; a