Complete the SQL statement to generate the Result table.

College

$\backslash$table$[[-$College,oCity$],[$Colgate$,$Hamilton$],[$Tufts$,$Medford$],[$Bowdoin$,$Brunswick$],[$Vassar$,$Poughkeepsie$]]$

$\backslash$table$[[$City$,$StateCode$],[$Hamilton$,$NY$],[$Medford$,$MA$],[$Brunswick$,$ME$],[$Poughkeepsie$,$NY$]]$

SELECT $/$TYpe your code here $*/$

FROM College, Location

WHERE $*/$Type your code here $*/$

Result

$\backslash$table$[[$College$,$StateCode$],[$Colgate$,$NY$],[$Tufts$,$MA$],[$Bowdoin$,$ME$],[$Vassar$,$I$]]$