Table: player_stats_1996
Columns: player
position
tries
goals
points

Question: Tell me the highest goals with tries less than 1 and fullback position
SQL: SELECT MAX("goals") FROM player_stats_1996 WHERE "tries" < 1 AND "position" = 'fullback'

Question: Tell me the lowest tries for goals more than 0 with centre position and points less than 54
SQL: SELECT MIN("tries") FROM player_stats_1996 WHERE "goals" > 0 AND "position" = 'centre' AND "points" < 54

Question: I want to know the player with tries more than 1 and position of hooker with points less than 54
SQL: SELECT "player" FROM player_stats_1996 WHERE "tries" > 1 AND "points" < 54 AND "position" = 'hooker'

Question: Tell me the player with points larger than 36 and goals more than 0 with tries of 12
SQL: SELECT "player" FROM player_stats_1996 WHERE "points" > 36 AND "goals" > 0 AND "tries" = 12