Table: scottish_challenge_cup_clubs
Columns: club
wins
last_final_won
runners_up
last_final_lost
total_final_appearances

Question: What club has over 1 runners-up and last won the final in 2010?
SQL: SELECT "club" FROM scottish_challenge_cup_clubs WHERE "runners_up" > 1 AND "last_final_won" = '2010'

Question: How manywins for dunfermline athletic that has a total final appearances less than 2?
SQL: SELECT "wins" FROM scottish_challenge_cup_clubs WHERE "total_final_appearances" < 2 AND "club" = 'dunfermline athletic'