w3resource
SQL exercises

SQL: Display the year and subject that won 'Dennis Gabor' his prize

SQL Basic Select Statement : Exercise-14 with Solution.

Write a SQL query to display the year and subject that won 'Dennis Gabor' his prize.

Sample table: nobel_win

 

Sample Solution :

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

Output:

SQL exercises

Query Visualization:

Duration:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - Duration

Rows:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - Rows

Cost:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - Cost

Practice Online


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

Previous: Write a SQL query to know the winner of the 1971 prize for Literature.
Next: Write a SQL query to give the name of the 'Physics' winners since the year 1950.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming