Which type has an abbreviation of B and Boarding/Day value of Boarding?
CREATE TABLE "houses" (
  "house" text,
  "abbr" text,
  "type" text,
  "colour" text,
  "boarding_day" text
);
SELECT "type" FROM "houses" WHERE "boarding_day"='boarding' AND "abbr"='b';