CS101 - SQL solutions

-- #1
select max(born) < min(died) from artist;

-- #2
select painting.title from painting, museum where
painting.museum = museum.id and
museum.name = 'Yale Art Gallery';

-- #3
select museum.city from painting, museum, artist where
painting.museum = museum.id and
painting.artist = artist.id and
artist.last = 'Degas';

-- #4
select painting.title from painting, museum where
painting.museum = museum.id and
museum.city = 'New York'
order by painting.year limit 1;

-- #5
select distinct artist.first, artist.last
from painting, museum, artist where
painting.museum = museum.id and
painting.artist = artist.id and
museum.country = artist.country;
PDF