Reference no: EM132323078

Go Bears! (And Dogs?)

Now that we have learned how to select columns from a SQL table, let's filter the results to see some more interesting results!

It turns out that our students have a lot of school spirit: the most popular favorite color was 'blue'. You would think that this school spirit would carry over to the pet answer, and everyone would want a pet bear! Unfortunately, this was not the case, and the majority of students opted to have a pet 'dog' instead. That is the more sensible choice, I suppose...

Create SQL query to make table that contains both the column color and the column pet, using the keyword WHERE to restrict the answers to the most popular results of color being 'blue' and pet being 'dog'. Note that some people put different names for dogs-i.e. putting specific dogs or putting 'puppy' instead of dog. Unfortunately, we would not be able to account for those cases. Something messy as data scientist you will have to deal with in collecting data.

You should get the following output:

sqlite> SELECT * FROM blue_dog;
blue|dog
blue|dog
blue|dog
CREATE TABLE blue_dog as
  -- REPLACE THIS LINE
  SELECT 'YOUR CODE HERE';