SQL: Show all the details of the Chemistry prize winners between the year 1965 to 1975 inclusive
SQL Basic Select Statement : Exercise-16 with Solution.
Write a SQL query to show all the details (year, subject, winner, country ) of the Chemistry prize winners between the year 1965 to 1975 inclusive.
Sample table : nobel_win
SELECT year, subject, winner, country FROM nobel_win WHERE subject = 'Chemistry' AND year>=1965 AND year<=1975;
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to give the name of the 'Physics' winners since the year 1950.
Next: Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.
What is the difficulty level of this exercise?