How many house mascots are associated with yellow house colours?
create table table_1942683_1 (house_mascot varchar, house_colour varchar, PRIMARY KEY (house_mascot))
select count(house_mascot) from table_1942683_1 where house_colour = "yellow"