SELECT WINNER
FROM NOBEL_WIN
WHERE YEAR = 1970 AND SUBJECT = 'Literature';

SELECT YEAR, SUBJECT, WINNER
FROM NOBEL_WIN
WHERE YEAR = 1970;

select customer_id, cust_name, city, grade, salesman_id
FROM customers
where grade = 200;


SELECT YEAR, SUBJECT, WINNER, COUNTRY, CATEGORY
FROM nobel_win
WHERE (YEAR = 1970 AND SUBJECT = 'Physics')
   OR (YEAR = 1971 AND SUBJECT = 'Economics');

SELECT *
FROM nobel_win
WHERE (CATEGORY = 'Prime Minister' OR CATEGORY = 'Scientist')
  AND YEAR < 1987;


SELECT YEAR, SUBJECT, WINNER, COUNTRY
FROM nobel_win
WHERE SUBJECT = 'Chemistry'
  AND YEAR between 1971 AND 1987;


SELECT YEAR, SUBJECT, WINNER, COUNTRY, CATEGORY
FROM nobel_win
WHERE YEAR = 1970
  AND SUBJECT NOT IN ('Physiology', 'Economics');


SELECT WINNER
FROM nobel_win
WHERE SUBJECT = 'Physics'
  AND YEAR >= 1950;

SELECT YEAR, SUBJECT
FROM nobel_win
WHERE WINNER = 'Dennis Gabor'

SELECT YEAR,SUBJECT, WINNER, COUNTRY, CATEGORY
FROM  nobel_win
WHERE winner like '%n'