user: Question: what is the latest year where glos & wilts is Warminster?
Columns: ['Year', 'Premier One', 'Premier Two', 'Bristol & Somerset', 'Glos & Wilts', 'Bristol & N. Som', 'Somerset', 'Gloucestershire', 'Wiltshire']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [2007.0, 'Frocester', 'Downend', 'Lansdown', 'Warminster', 'Winterbourne', 'Winscombe', 'Rockhampton', 'Wootton Bassett']
SQL:

assistant: SELECT MAX("Year") FROM "Table" WHERE "Glos & Wilts" = 'Warminster';