SQL: Display the Nobel prizes for 1970
SQL Basic Select Statement : Exercise-12 with Solution.
Write a SQL query to display the Nobel prizes for 1970.
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
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a sql query to display the order number followed by order date and the purchase amount for each order which will be delivered by the salesman who is holding the ID 5001.
Next: Write a SQL query to know the winner of the 1971 prize for Literature.
What is the difficulty level of this exercise?