Table: engineering_colleges_tn
Columns: college_or_campus_name
location
district
affiliation
estd
weblink

Question: In which district is anna university - tiruchirappalli campus, whose website is http://www.annauniv.edu, located?
SQL: SELECT "district" FROM engineering_colleges_tn WHERE "weblink" = 'http://www.annauniv.edu' AND "college_or_campus_name" = 'anna university - tiruchirappalli campus'

Question: In what year was anna university - panruti campus established?
SQL: SELECT SUM("estd") FROM engineering_colleges_tn WHERE "college_or_campus_name" = 'anna university - panruti campus'

Question: Which district was established in 1942?
SQL: SELECT "district" FROM engineering_colleges_tn WHERE "estd" = 1942

Question: What is the affiliation for the Cuddalore District?
SQL: SELECT "affiliation" FROM engineering_colleges_tn WHERE "district" = 'cuddalore district'

Question: Which College or campus has a website of http://www.aucev.edu.in/?
SQL: SELECT "college_or_campus_name" FROM engineering_colleges_tn WHERE "weblink" = 'http://www.aucev.edu.in/'