Table: paul_robinson
Columns: name
position
apps
goals
assists

Question: What is the name of the player with more than 0 assists, a position of forward, 19 goals, and more than 84 apps?
SQL: SELECT "name" FROM paul_robinson WHERE "assists" > 0 AND "position" = 'forward' AND "apps" > 84 AND "goals" = 19

Question: What is the total goals with 12 assists, and less than 291 apps?
SQL: SELECT SUM("goals") FROM paul_robinson WHERE "assists" = 12 AND "apps" < 291

Question: What is the total of apps for Keith Treacy?
SQL: SELECT SUM("apps") FROM paul_robinson WHERE "name" = 'keith treacy'