Table: hk_football_stats
Columns: team
game
draw
loss
goal_gain
goal_loss
goal_diff
point

Question: How many points did Happy Valley score before game 14?
SQL: SELECT COUNT("point") FROM hk_football_stats WHERE "team" = 'happy valley' AND "game" < 14

Question: How many points were there in the game with a goal loss of 16 and a goal diff less than 26 after game 14?
SQL: SELECT COUNT("point") FROM hk_football_stats WHERE "goal_loss" = 16 AND "goal_diff" < 26 AND "game" > 14

Question: How many draws did the game after game 14 with goal gain 17 have?
SQL: SELECT MAX("draw") FROM hk_football_stats WHERE "goal_gain" = 17 AND "game" > 14

Question: How many total draws were there with a less than 8 loss, more than 30 points, and a goal diff larger than 26?
SQL: SELECT COUNT("draw") FROM hk_football_stats WHERE "loss" < 8 AND "point" > 30 AND "goal_diff" > 26

Question: What is the highest loss before game 14?
SQL: SELECT MAX("loss") FROM hk_football_stats WHERE "game" < 14