● CollegeName City Enrollment Columbia New York 6202 MIT Cambridge 11376 Location ● City StateCode Portland OR Northampton MA New York NY Cambridge MA An arrow points from the College table’s City…
● CollegeName City Enrollment Columbia New York 6202 MIT Cambridge 11376 Location ● City StateCode Portland OR Northampton MA New York NY Cambridge MA An arrow points from the College table’s City column to the Location table’s primary key column.Complete the SQL statement to generate the Result table. The column names in the SELECT clause must match the Result table exactly.SELECT FROM College, Location WHERE /* Type your code here */ /* Type your code here */ Result College.City StateCode New York NY Cambridge
OR