CREATE TABLE table_name_42 (kit_maker VARCHAR, team VARCHAR)

Which kit maker does Aston Villa use?
SELECT kit_maker FROM table_name_42 WHERE team = "aston villa"
SELECT "kit_maker" FROM "table_name_42" WHERE "aston villa" = "team"