CREATE TABLE table_12043148_2 (year INT, glos_ VARCHAR, _wilts VARCHAR)

what is the latest year where glos & wilts is warminster?
SELECT MAX(year) FROM table_12043148_2 WHERE glos_ & _wilts = "Warminster"
SELECT MAX("year") FROM "table_12043148_2" WHERE "Warminster" = "glos_" & "_wilts"