Problem 1: Size of Dogs (100 pts)
The Fédération Cynologique Internationale classifies a standard poodle as over 45 cm and up to 60 cm. The sizes
table describes this and other such classifications, where a dog must be over the min
and less than or equal to the max
in height
to qualify as a size
.
Create a size_of_dogs
table with two columns, one for each dog's name
and another for its size
.
-- The size of each dog
CREATE TABLE size_of_dogs AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
The output should look like the following:
sqlite> select * from size_of_dogs;
abraham|toy
barack|standard
clinton|standard
delano|standard
eisenhower|mini
fillmore|mini
grover|toy
herbert|mini