What's the highest Date listed that has U-boats destroyed (Pola) of 1?
CREATE TABLE table_name_97 (date INTEGER, u_boats_destroyed__pola_ VARCHAR)
SELECT MAX(date) FROM table_name_97 WHERE u_boats_destroyed__pola_ = "1"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (date INTEGER, u_boats_destroyed__pola_ VARCHAR) Question: What's the highest Date listed that has U-boats destroyed (Pola) of 1? [/INST] SELECT MAX(date) FROM table_name_97 WHERE u_boats_destroyed__pola_ = "1" </s>