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

Last update on June 10 2022 09:26:38 (UTC/GMT +8 hours)

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 Tree:

Duration:

Rows:

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