SQL Exercises: Details of the prize won by Johannes Georg Bednorz

SQL Basic Select Statement: Exercise-22 with Solution.

From the following table, write a SQL query to find the details of the Nobel Prize winner 'Johannes Georg Bednorz'. Return year, subject, winner, country, and category.

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

Code Explanation:

The above SQL query retrieves all columns from the 'nobel_win' table where the winner is 'Johannes Georg Bednorz'. The query will return all rows that match this criteria, resulting in a list of all Nobel Prizes awarded to 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 Python Exercise: Physiology prize before 71 with a Peace prize after 74.
Next Python Exercise: Subjects not start with P, sorted by most recent, name.