SQL: The year and subject of the prize that was awarded to 'Dennis Gabor'

SQL Basic Select Statement: Exercise-14 with Solution.

From the following table, write a SQL query to locate the Nobel Prize winner ‘Dennis Gabor'. Return year, subject.

Sample table: nobel_win

Sample Solution:

SELECT year, subject
  FROM nobel_win
 WHERE winner = 'Dennis Gabor';

Output of the Query:

year	subject
1971	Physics

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 in ‘Literature’ in the year 1970. Return winner.
Next: From the following table, write a SQL query to find the Nobel Prize winners in 'Physics' since the year 1950. Return winner.