Table: school_medallion_shield
Columns: school
titles
shared_titles
runners_up
total_finals
last_title
last_final

Question: How many shared titles does the club whose last final was 2012 have?
SQL: SELECT "shared_titles" FROM school_medallion_shield WHERE "last_final" = 2012

Question: What was the year of the last final for the club whose last title was 1990?
SQL: SELECT "last_final" FROM school_medallion_shield WHERE "last_title" = '1990'

Question: What is the minimum number of shared titles for the club whose last final was in 2006?
SQL: SELECT MIN("shared_titles") FROM school_medallion_shield WHERE "last_final" = 2006

Question: What is the latest year of last final for the club whose last title was in 1994?
SQL: SELECT MAX("last_final") FROM school_medallion_shield WHERE "last_title" = '1994'

Question: What are the number of runners up for Royal School Dungannon?
SQL: SELECT "runners_up" FROM school_medallion_shield WHERE "school" = 'Royal School Dungannon'