w3resource
SQL exercises

SQL: Who won the 1971 prize for Literature

SQL Basic Select Statement : Exercise-13 with Solution.

Write a SQL query to know the winner of the 1971 prize for Literature.

Sample table : nobel_win

 

Sample Solution :

SELECT winner
  FROM nobel_win
 WHERE year = 1971
   AND subject = 'Literature';

Output of the Query:

winner
Pablo Neruda

Query Visualization:

Duration:

Query visualization of Who won the 1971 prize for Literature - Duration

Rows:

Query visualization of Who won the 1971 prize for Literature - Rows

Cost:

Query visualization of Who won the 1971 prize for Literature - Cost

 

Practice Online


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

Previous: Write a SQL query to display the Nobel prizes for 1970.
Next: Write a SQL query to display the year and subject that won 'Dennis Gabor' his prize.

What is the difficulty level of this exercise?



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