w3resource

SQL: The year and subject of the prize that was awarded to 'Dennis Gabor'

SQL Basic Select Statement: Exercise-14 with Solution.

From the following table, write a SQL query to locate the Nobel Prize winner ‘Dennis Gabor'. Return year, subject.

Sample table: nobel_win

 

Sample Solution:

SELECT year, subject
  FROM nobel_win
 WHERE winner = 'Dennis Gabor';

Output of the Query:

year	subject
1971	Physics

Relational Algebra Expression:

Relational Algebra Expression: Display the year and subject that won 'Dennis Gabor' his prize.

Relational Algebra Tree:

Relational Algebra Tree: Display the year and subject that won 'Dennis Gabor' his prize.

Practice Online


Query Visualization:

Duration:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - Duration

Rows:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - Rows

Cost:

Query visualization of Display the year and subject that won 'Dennis Gabor' his prize - 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 find the Nobel Prize winner in ‘Literature’ in the year 1970. Return winner.
Next: From the following table, write a SQL query to find the Nobel Prize winners in 'Physics' since the year 1950. Return winner.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

Nested select statement in SQL Server.

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a 

or to be more explicit

SELECT a.name FROM (SELECT name FROM agentinformation) a  

Database: SQL Server

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