Advertisement
Guest User

Untitled

a guest
Dec 7th, 2019
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT country_name,subject, COUNT(Scientist_ID) FROM scientist,scientist_subject,country_of_birth,research_area WHERE scientist.ISO_Code = Country_of_birth.ISO_code AND scientist.ID = Scientist_subject.Scientist_ID AND research_area.subject_code = scientist_subject.subject_code ANd country_name IN ("Germany","Sweden") AND subject = "Chemistry" GROUP BY country_name, subject;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement