SELECT-from-nobel.sql

--SELECT from nobel
--1
SELECT * FROM nobel
WHERE yr = '1950';
--2
SELECT winner FROM nobel
WHERE yr = 1962 AND subject = 'Literature';
--3
SELECT yr,sbject FROM nobel
WHERE winner = 'Alber Einstein';
--4
SELECT winner FROM nobel
WHERE subject = 'Peace' AND yr >= 2000;
--5
SELECT * FROM nobel
WHERE subject = 'Literature' AND
yr BETWEEN '1980' AND '1989';
--6
SELECT * FROM nobel
WHERE winner IN ('Theodore Roosevelt','Woodrow Wilson',
'Jimmy Carter','Barack Obama');
--7
SELECT winner FROM nobel
WHERE winner LIKE 'John%';
--8
SELECT * FROM nobel
WHERE (subject='Chemistry' AND yr = '1984');
--9
SELECT * FROM nobel
WHERE yr='1980' AND subject NOT IN ('Chemistry','Medicine');
--10
SELECT * FROM nobel
WHERE (subject = 'Medicine' AND yr < 1910) OR (subject = 'Literature'
AND yr >= 2004);
--11
SELECT * FROM nobel
WHERE winner = 'Peter Gr_nberg';
--12
SELECT * FROM nobel
WHERE winner = 'Eugene O\Neill';
--13
SELECT winner, yr, subject FROM nobel
WHERE winner LIKE 'Sir%'
ORDER BY DESC, winner;
--14
SELECT winner, subject
FROM nobel
WHERE yr=1841
ORDER BY subject IN ('Physic','Chemistry'), subject, winner;