-
Notifications
You must be signed in to change notification settings - Fork 1
/
task3.sql
28 lines (28 loc) · 1.1 KB
/
task3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
-- 1
SELECT yr, subject, winner FROM nobel WHERE yr = 1950
-- 2
SELECT winner FROM nobel WHERE yr = 1962 AND subject = 'Literature'
-- 3
SELECT yr, subject FROM nobel WHERE winner = 'Albert Einstein'
-- 4
SELECT winner FROM nobel WHERE subject = 'Peace' and yr >=2000
-- 5
SELECT * FROM nobel WHERE SUBJECT = 'Literature' and yr>=1980 and yr<=1989
-- 6
SELECT * FROM nobel WHERE winner IN ('Theodore Roosevelt','Woodrow Wilson','Jimmy Carter','Barack Obama')
-- 7
SELECT winner FROM nobel WHERE LEFT(winner,4)='John'
-- 8
SELECT * FROM nobel WHERE subject = 'Physics' AND yr = 1980 OR subject = 'Chemistry' AND yr = 1984
-- 9
SELECT * FROM nobel WHERE subject NOT IN ('Chemistry','Medicine') and yr = 1980
-- 10
SELECT * FROM nobel WHERE yr<1910 and subject = 'Medicine' 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 yr DESC
-- 14
SELECT winner, subject FROM nobel WHERE yr=1984 ORDER BY subject IN ('Physics','Chemistry'),subject,winner