Table: macleans_house
Columns: house_name
house_mascot
house_colour
year_opened
house_leader

Question: What is the earliest year a house opened?
SQL: SELECT MIN("year_opened") FROM macleans_house

Question: How many house colours are associated with house names of Hillary?
SQL: SELECT COUNT("house_colour") FROM macleans_house WHERE "house_name" = 'Hillary'

Question: What is the house colour associated with the house name of Kupe?
SQL: SELECT "house_colour" FROM macleans_house WHERE "house_name" = 'Kupe'

Question: How many house mascots are associated with yellow house colours?
SQL: SELECT COUNT("house_mascot") FROM macleans_house WHERE "house_colour" = 'Yellow'