Table: medical_colleges
Columns: college_name
location
district
affiliation
estd

Question: What is the location of the kanyakumari government medical college?
SQL: SELECT "location" FROM medical_colleges WHERE "college_name" = 'kanyakumari government medical college'

Question: Where is the coimbatore affilation that was established in 1982?
SQL: SELECT "affiliation" FROM medical_colleges WHERE "estd" = '1982' AND "location" = 'coimbatore'

Question: What is the location of the salem district?
SQL: SELECT "location" FROM medical_colleges WHERE "district" = 'salem district'

Question: What is the location of the tiruchirappalli district?
SQL: SELECT "location" FROM medical_colleges WHERE "district" = 'tiruchirappalli district'

Question: What is the district where the thanjavur medical college is located?
SQL: SELECT "district" FROM medical_colleges WHERE "college_name" = 'thanjavur medical college'

Question: Where is the location of the coimbatore medical college?
SQL: SELECT "location" FROM medical_colleges WHERE "college_name" = 'coimbatore medical college'