Answer to Question #67334 in Databases | SQL | Oracle | MS Access for bug
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.
from STUDENT s inner join ADDRESS a using(POSTAL_CODE)
where a.PLACE_NAME like '%Toronto%'
and s.PROGRAM_NUMBER = 'BSC2'
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!
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)