Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL: Find all 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

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: From the following table, write a SQL query to combine the winners in 'Physiology' before 1971 and winners in 'Peace' on or after 1974. Return year, subject, winner, country, and category.
Next: From the following table, write a SQL query to find the Nobel Prize winners for the subject not started with the letter 'P'. Return year, subject, winner, country, and category. Order the result by year, descending.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

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