Name the most goals for total club and apps less than 120
CREATE TABLE table_name_34 (goals INTEGER, club VARCHAR, apps VARCHAR)
SELECT MAX(goals) FROM table_name_34 WHERE club = "total" AND apps < 120
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_34 (goals INTEGER, club VARCHAR, apps VARCHAR) Question: Name the most goals for total club and apps less than 120 [/INST] SELECT MAX(goals) FROM table_name_34 WHERE club = "total" AND apps < 120 </s>