Complete the SQL statement to generate the Result table.

College StateCode

Pomona CA

Tufts MA

Hamilton NY

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

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

Location

$$City StateCode

Claremont CA

Medford MA

Clinton NY

College

$$College $$City Enrollment

Pomona Claremont $1663$

Tufts Medford $10872$

Hamilton Clinton $1859$

Result;