col : school | location | outright titles | shared titles | runners-up | total finals | last title | last final row 1 : methodist college belfast | belfast | 35 | 2 | 25 | 62 | 2014.0 | 2014 row 2 : royal belfast academical institution | belfast | 29 | 4 | 21 | 54 | 2007.0 | 2013 row 3 : campbell college | belfast | 23 | 4 | 12 | 39 | 2011.0 | 2011 row 4 : coleraine academical institution | coleraine | 9 | 0 | 24 | 33 | 1992.0 | 1998 row 5 : the royal school, armagh | armagh | 9 | 0 | 3 | 12 | 2004.0 | 2004 row 6 : portora royal school | enniskillen | 6 | 1 | 5 | 12 | 1942.0 | 1942 row 7 : bangor grammar school | bangor | 5 | 0 | 4 | 9 | 1988.0 | 1995 row 8 : ballymena academy | ballymena | 3 | 0 | 6 | 9 | 2010.0 | 2010 row 9 : rainey endowed school | magherafelt | 2 | 1 | 2 | 5 | 1982.0 | 1982 row 10 : foyle college | londonderry | 2 | 0 | 4 | 6 | 1915.0 | 1915 row 11 : belfast royal academy | belfast | 1 | 3 | 5 | 9 | 1997.0 | 2010 row 12 : regent house grammar school | newtownards | 1 | 1 | 2 | 4 | 1996.0 | 2008 row 13 : royal school dungannon | dungannon | 1 | 0 | 4 | 5 | 1907.0 | 1975 row 14 : annadale grammar school (now wellington college) | belfast | 1 | 0 | 1 | 2 | 1958.0 | 1978 row 15 : ballyclare high school | ballyclare | 1 | 0 | 1 | 2 | 1973.0 | 2012 row 16 : belfast boys' model school | belfast | 1 | 0 | 0 | 1 | 1971.0 | 1971 row 17 : grosvenor high school | belfast | 1 | 0 | 0 | 1 | 1983.0 | 1983 row 18 : wallace high school | lisburn | 0 | 0 | 4 | 4 | nan | 2007 row 19 : derry academy | derry | 0 | 0 | 2 | 2 | nan | 1896 row 20 : dalriada school | ballymoney | 0 | 0 | 1 | 1 | nan | 1993 row 21 : galway grammar school | galway | 0 | 0 | 1 | 1 | nan | 1887 row 22 : lurgan college | lurgan | 0 | 0 | 1 | 1 | nan | 1934 row 23 : omagh academy | omagh | 0 | 0 | 1 | 1 | nan | 1985 row 24 : sullivan upper school | holywood | 0 | 0 | 1 | 1 | nan | 2014
which colleges participated in the ulster's schools' cup?
methodist college belfast, royal belfast academical institution, campbell college, coleraine academical institution, the royal school, armagh, portora royal school, bangor grammar school, ballymena academy, rainey endowed school, foyle college, belfast royal academy, regent house grammar school, royal school dungannon, annadale grammar school (now wellington college), ballyclare high school, belfast boys' model school, grosvenor high school, wallace high school, derry academy, dalriada school, galway grammar school, lurgan college, omagh academy, sullivan upper school
School Location Outright Titles Shared Titles Runners-Up Total Finals Last Title Last Final
which colleges participated in the ulster's schools' cup?
Methodist College Belfast Belfast 35 2 25 62 2014.0 2014
Royal Belfast Academical Institution Belfast 29 4 21 54 2007.0 2013
Campbell College Belfast 23 4 12 39 2011.0 2011
Coleraine Academical Institution Coleraine 9 0 24 33 1992.0 1998
The Royal School, Armagh Armagh 9 0 3 12 2004.0 2004
Portora Royal School Enniskillen 6 1 5 12 1942.0 1942
Bangor Grammar School Bangor 5 0 4 9 1988.0 1995
Ballymena Academy Ballymena 3 0 6 9 2010.0 2010
Rainey Endowed School Magherafelt 2 1 2 5 1982.0 1982
Foyle College Londonderry 2 0 4 6 1915.0 1915
Belfast Royal Academy Belfast 1 3 5 9 1997.0 2010
Regent House Grammar School Newtownards 1 1 2 4 1996.0 2008
Royal School Dungannon Dungannon 1 0 4 5 1907.0 1975
Annadale Grammar School (now Wellington College) Belfast 1 0 1 2 1958.0 1978
Ballyclare High School Ballyclare 1 0 1 2 1973.0 2012
Belfast Boys' Model School Belfast 1 0 0 1 1971.0 1971
Grosvenor High School Belfast 1 0 0 1 1983.0 1983
Wallace High School Lisburn 0 0 4 4 nan 2007
Derry Academy Derry 0 0 2 2 nan 1896
Dalriada School Ballymoney 0 0 1 1 nan 1993
Galway Grammar School Galway 0 0 1 1 nan 1887
Lurgan College Lurgan 0 0 1 1 nan 1934
Omagh Academy Omagh 0 0 1 1 nan 1985
Sullivan Upper School Holywood 0 0 1 1 nan 2014
Methodist College Belfast Royal Belfast Academical Institution Campbell College Coleraine Academical Institution The Royal School, Armagh Portora Royal School Bangor Grammar School Ballymena Academy Rainey Endowed School Foyle College Belfast Royal Academy Regent House Grammar School Royal School Dungannon Annadale Grammar School (now Wellington College) Ballyclare High School Belfast Boys' Model School Grosvenor High School Wallace High School Derry Academy Dalriada School Galway Grammar School Lurgan College Omagh Academy Sullivan Upper School
which colleges participated in the ulster's schools' cup? || 