moma_hudi_changes.sql

-- 'Picador (La Pique)', by Pablo Picasso
SELECT * 
FROM artworks 
WHERE artwork_id = 128447 AND classification = 'Print';

-- firts update (creation date)
UPDATE artworks
SET date = 1959
WHERE artwork_id = 128447;

-- second update (acquisition date)
UPDATE artworks
SET acquisition_date = '2009-04-15'
WHERE artwork_id = 128447;

-- third update (in vs. '')
UPDATE artworks
SET dimensions = 'composition: 20 13/16 x 25 3/16 in (52.9 x 64 cm); sheet: 24 7/16 x 29 1/2 in (62.1 x 75 cm)'
WHERE artwork_id = 128447;

-- fourth update (acquisition date)
UPDATE artworks
SET acquisition_date = '2009-04-19'
WHERE artwork_id = 128447;