w3resource
SQL exercises

SQL: Find all details of the prize won by Johannes Georg Bednorz

SQL Basic Select Statement: Exercise-22 with Solution.

Write a SQL query to find all details of the prize won by Johannes Georg Bednorz.

Sample table : nobel_win

 

Sample Solution :

SELECT *
 FROM nobel_win 
   WHERE winner='Johannes Georg Bednorz';

Output of the Query:

year	subject	winner			country	  category
1987	Physics	Johannes Georg Bednorz	Germany	Scientist

Practice Online


Query Visualization:

Duration:

Query visualization of Find all details of the prize won by Johannes Georg Bednorz - Duration

Rows:

Query visualization of Find all details of the prize won by Johannes Georg Bednorz - Rows

Cost:

Query visualization of Find all details of the prize won by Johannes Georg Bednorz - Cost

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

Previous: Write a SQL query to show the winners of a 'Physiology' prize in an early year before 1971 together with winners of a 'Peace' prize in a later year on and after the 1974.
Next: Write a SQL query to find all the details of the nobel winners for the subject not started with the letter 'P' and arranged the list as the most recent comes first, then by name in order.

What is the difficulty level of this exercise?