● CollegeName City Enrollment Emory Atlanta 14769 Tufts Medford 10872 Duke Durham 15192 Location ● City StateCode Atlanta GA Medford MA Durham NC An arrow points from the College table’s City colu…
● CollegeName City Enrollment Emory Atlanta 14769 Tufts Medford 10872 Duke Durham 15192 Location ● City StateCode Atlanta GA Medford MA Durham NC 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 Enrollment StateCode 14769 GA 10872 MA 15192 NC
OR