Question #67334
Write a query to list all Torontonian (Place name contains ‘Toronto’) students (name,
number, Hall-name) enrolled in the B.S. in Computer Science (program code ‘BSC2’)
Student table containing L/FName(s), Number, Hall-name, program_number and postal code (used to identify place_name which is toronto)
Address table containing postal code, place name and province.
program table containing program_number and program_name.
number, Hall-name) enrolled in the B.S. in Computer Science (program code ‘BSC2’)
Student table containing L/FName(s), Number, Hall-name, program_number and postal code (used to identify place_name which is toronto)
Address table containing postal code, place name and province.
program table containing program_number and program_name.
Expert's answer
select *
from STUDENT s inner join ADDRESS a using(POSTAL_CODE)
where a.PLACE_NAME like '%Toronto%'
and s.PROGRAM_NUMBER = 'BSC2'
from STUDENT s inner join ADDRESS a using(POSTAL_CODE)
where a.PLACE_NAME like '%Toronto%'
and s.PROGRAM_NUMBER = 'BSC2'
