Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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