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
what were all of the school names? how many outright titles did they achieve? and how many did coleraine academical institution receive?
9
School Location Outright Titles Shared Titles Runners-Up Total Finals Last Title Last Final
and how many did coleraine academical institution receive?
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
9
and how many did coleraine academical institution receive? || how many outright titles did they achieve? | what were all of the school names?