w3resource
Run SQL Query

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?



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

Can a foreign key be NULL and/or duplicate?

First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That is all an Foreign key is by definition. Null by definition is not a value. Null means that we do not yet know what the value is.

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