Table: scottish_youth_cup
Columns: club
wins
last_win
runners_up
last_final_lost

Question: How many wins did Ayr United have?
SQL: SELECT "wins" FROM scottish_youth_cup WHERE "club" = 'ayr united'

Question: When was the final loss of the club last won in 2001 and has a total of 3 wins?
SQL: SELECT "last_final_lost" FROM scottish_youth_cup WHERE "wins" = '3' AND "last_win" = '2001'

Question: When was the last win for the club that had a final loss in 2011?
SQL: SELECT "last_win" FROM scottish_youth_cup WHERE "last_final_lost" = '2011'

Question: How many wins did the 8 time runner-up have?
SQL: SELECT "wins" FROM scottish_youth_cup WHERE "runners_up" = '8'

Question: How many wins did the club have with the last win in 2000?
SQL: SELECT "wins" FROM scottish_youth_cup WHERE "last_win" = '2000'