w3resource
SQL exercises

SQL: Show all the details of the Chemistry prize winners between the year 1965 to 1975 inclusive

SQL Basic Select Statement : Exercise-16 with Solution.

Write a SQL query to show all the details (year, subject, winner, country ) of the Chemistry prize winners between the year 1965 to 1975 inclusive.

Sample table : nobel_win

 

Sample Solution:

SELECT year, subject, winner, country
  FROM nobel_win
 WHERE subject = 'Chemistry'
   AND year>=1965 AND year<=1975;

Output:

SQL exercises

Query Visualization:

Duration:

Query visualization of Show all the details of the Chemistry prize winners between the year 1965 to 1975 inclusive - Duration

Rows:

Query visualization of Show all the details of the Chemistry prize winners between the year 1965 to 1975 inclusive - Rows

Cost:

Query visualization of Show all the details of the Chemistry prize winners between the year 1965 to 1975 inclusive - Cost

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL query to give the name of the 'Physics' winners since the year 1950.
Next: Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming