Table: all_ireland_schools_boys
Columns: school
winners
finalists
total_finals
year_of_last_win

Question: What the name of  the school where the last win in 2007-08?
SQL: SELECT "school" FROM all_ireland_schools_boys WHERE "year_of_last_win" = '2007-08'

Question: How many times was banbridge academy the winner?
SQL: SELECT COUNT("winners") FROM all_ireland_schools_boys WHERE "school" = 'Banbridge Academy'

Question: What are the names that had a finalist score of 2?
SQL: SELECT "school" FROM all_ireland_schools_boys WHERE "finalists" = 2

Question: In what year was the total finals at 10?
SQL: SELECT "year_of_last_win" FROM all_ireland_schools_boys WHERE "total_finals" = 10

Question: What is the name of the school where the year of last win is 1985-86?
SQL: SELECT "school" FROM all_ireland_schools_boys WHERE "year_of_last_win" = '1985-86'

Question: How many total finals where there when the last win was in 2012-13?
SQL: SELECT "total_finals" FROM all_ireland_schools_boys WHERE "year_of_last_win" = '2012-13'