6. Write a SQL query to find the Nobel Prize winners in ‘Chemistry’ between the years 1965 and 1975.

Описание: Write a SQL query to find the Nobel Prize winners in ‘Chemistry’ between the years 1965 and 1975.

*table: nobel_win with columns year,name,city,commission