SQL: Filter the name of the 'Physics' winners since the year 1950
SQL Basic Select Statement: Exercise-15 with Solution.
Write a SQL query to give the name of the 'Physics' winners since the year 1950.
Sample table: nobel_win
Sample Solution :
SELECT winner FROM nobel_win WHERE year>=1950 AND subject='Physics';
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to display the year and subject that won 'Dennis Gabor' his prize.
Next: 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.
What is the difficulty level of this exercise?