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'
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
#339914 on Dec 2023
#339914 on Dec 2023
Comments
Of course, but * looks more general in format of our questions/answers.
instead of select * it is better practice to suggest fields like FirstName, LastName to maintaine data integrity in the future (mainly used in the industry when databases are constantly changing)