programming-examples/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.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

6 lines

282 B

SQL

Raw Permalink Blame History

 /*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.*/
 SELECT year, subject, winner, country
   FROM nobel_win
  WHERE subject = 'Chemistry'
    AND year>=1965 AND year<=1975;