what is the maximum season where leading goalkicker is scott simister (54)
CREATE TABLE table_1165048_1 (season INTEGER, leading_goalkicker VARCHAR)
SELECT MAX(season) FROM table_1165048_1 WHERE leading_goalkicker = "Scott Simister (54)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1165048_1 (season INTEGER, leading_goalkicker VARCHAR) Question: what is the maximum season where leading goalkicker is scott simister (54) [/INST] SELECT MAX(season) FROM table_1165048_1 WHERE leading_goalkicker = "Scott Simister (54)" </s>