Table: joseph_lindsay_football_match
Columns: date
venue
score
result
competition

Question: When was there a result of 8-1 and a score of 8-1?
SQL: SELECT "date" FROM joseph_lindsay_football_match WHERE "result" = '8-1' AND "score" = '8-1'

Question: When was there a result of 5-1?
SQL: SELECT "date" FROM joseph_lindsay_football_match WHERE "result" = '5-1'

Question: When was there a score of 7-1?
SQL: SELECT "date" FROM joseph_lindsay_football_match WHERE "score" = '7-1'

Question: What is the result when the score is 8-1?
SQL: SELECT "result" FROM joseph_lindsay_football_match WHERE "score" = '8-1'

Question: What is the competition type when the score is 1-1?
SQL: SELECT "competition" FROM joseph_lindsay_football_match WHERE "score" = '1-1'