SQL: Filter the names of the Physics award winners since 1950

SQL Basic Select Statement: Exercise-15 with Solution.

From the following table, write a SQL query to find the Nobel Prize winners in the field of ‘Physics’ since 1950. Return winner.

Sample table: nobel_win

Sample Solution :

SELECT winner 
FROM nobel_win
WHERE year>=1950
AND subject='Physics';

Output of the Query:

winner
Hannes Alfven
Louis Neel
Dennis Gabor
Johannes Georg Bednorz

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the Nobel Prize winner 'Dennis Gabor'. Return year, subject.
Next: From the following table, write a SQL query to find the Nobel Prize winners in ‘Chemistry’ between the years 1965 to 1975. Begin and end values are included. Return year, subject, winner, and country