SQL Exercises: Display the Nobel prizes for 1970
SQL Basic Select Statement: Exercise-12 with Solution.
From the following table, write a SQL query to find the Nobel Prize winner(s) for the year 1970. Return year, subject and winner.
Sample table : nobel_win
Sample Solution :
SELECT year,subject,winner FROM nobel_win WHERE year=1970;
Output of the Query:
year subject winner 1970 Physics Hannes Alfven 1970 Physics Louis Neel 1970 Chemistry Luis Federico Leloir 1970 Physiology Julius Axelrod 1970 Physiology Ulf von Euler 1970 Physiology Bernard Katz 1970 Literature Aleksandr Solzhenitsyn 1970 Economics Paul Samuelson
The above query in SQL that selects the "year", "subject" and "winner" columns from the 'nobel_win' table where the value of "year" column is 1970. The WHERE clause is used to filter the rows and only return the rows that match the condition specified in the WHERE clause.
Relational Algebra Expression:
Relational Algebra Tree:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous SQL Exercise: Order which will be delivered by a specified salesman.
Next SQL Exercise: Who won the 1971 Nobel Prize for Literature?.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
SQL: Tips of the Day
How to avoid the "divide by zero" error in SQL?
Select Case when divisor=0 then null Else dividend / divisor End ,,,
Select dividend / NULLIF(divisor, 0) ...
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
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