What is the composition of the coin that was issued after 2008, had a mintage larger than 999, and was designed by Jody Broomfield?
CREATE TABLE table_name_76 (composition VARCHAR, year VARCHAR, mintage VARCHAR, artist VARCHAR)
SELECT composition FROM table_name_76 WHERE mintage > 999 AND artist = "jody broomfield" AND year > 2008
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (composition VARCHAR, year VARCHAR, mintage VARCHAR, artist VARCHAR) Question: What is the composition of the coin that was issued after 2008, had a mintage larger than 999, and was designed by Jody Broomfield? [/INST] SELECT composition FROM table_name_76 WHERE mintage > 999 AND artist = "jody broomfield" AND year > 2008 </s>