w3resource

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 Expression: Find all details of the prize won by Johannes Georg Bednorz.

Relational Algebra Tree:

Relational Algebra Tree: Find all details of the prize won by Johannes Georg Bednorz.

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 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.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.

SQL: Tips of the Day

What is the best way to paginate results in SQL Server?

SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
          FROM      Orders
          WHERE     OrderDate >= '1980-01-01'
        ) AS RowConstrainedResult
WHERE   RowNum >= 1
    AND RowNum < 20
ORDER BY RowNum

Database: SQL Server

Ref: https://bit.ly/3MGrNlk

 





We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook