62 556
Assignments Done
98,8%
Successfully Done
In June 2018

Answer to Question #67334 in Databases | SQL | Oracle | MS Access for bug

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.

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'

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!

Comments

Assignment Expert
29.10.17, 11:58

Of course, but * looks more general in format of our questions/answers.

Iain fraser
26.10.17, 12:24

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)

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions