Table: national_college_nursing
Columns: english_name
japanese_orthography
pronouciation
abbreviation
provider_iai
foundation

Question: Which colleges have the english abbreviation MTC?
SQL: SELECT "english_name" FROM national_college_nursing WHERE "abbreviation" = 'MTC'

Question: What is the Japanese orthography for the English name National Farmers Academy?
SQL: SELECT "japanese_orthography" FROM national_college_nursing WHERE "english_name" = 'National Farmers Academy'

Question: What is the abbreviation for the college pronounced "kōkū daigakkō"?
SQL: SELECT "abbreviation" FROM national_college_nursing WHERE "pronouciation" = 'Kōkū Daigakkō'

Question: How many providers were founded in 1964?
SQL: SELECT COUNT("provider_iai") FROM national_college_nursing WHERE "foundation" = 1964

Question: What is the Japanese orthography for National Fisheries University?
SQL: SELECT "japanese_orthography" FROM national_college_nursing WHERE "english_name" = 'National Fisheries University'