Table: rugby_union_world_cup
Columns: year
host_nation_s
final_venue
winner
result
runner_up

Question: What are all the winning records when the result is Scotland won on points table and the Runner-Up result is [[|]] 4 points?
SQL: SELECT "winner" FROM rugby_union_world_cup WHERE "result" = 'Scotland won on points table' AND "runner_up" = '[[|]] 4 points'

Question: What is the runner-up record where winner record is Ireland 59 points?
SQL: SELECT "runner_up" FROM rugby_union_world_cup WHERE "winner" = 'Ireland 59 points'

Question: Which nation hosted the competition in 2004?
SQL: SELECT "host_nation_s" FROM rugby_union_world_cup WHERE "year" = 2004

Question: What was the final venue whene England hasted the competition and the runner-up record is [[|]] 4 points and the winner record is [[|]] 6 points?
SQL: SELECT "final_venue" FROM rugby_union_world_cup WHERE "host_nation_s" = 'England' AND "runner_up" = '[[|]] 4 points' AND "winner" = '[[|]] 6 points'

Question: What is the most recent year in which the winner record is Ireland 4 points?
SQL: SELECT MAX("year") FROM rugby_union_world_cup WHERE "winner" = 'Ireland 4 points'