begin;

/* Exact match */
update collection set name = 'Hard Rock Cafe Amsterdam' where name = 'Amsterdam';
update collection set name = 'Hard Rock Cafe Barcelona' where name = 'Barcelona';
update collection set name = 'Hard Rock Cafe Berlin' where name = 'Berlin';
update collection set name = 'Hard Rock Cafe Brussels' where name = 'Brussels';
update collection set name = 'Hard Rock Cafe Dublin' where name = 'Dublin';
update collection set name = 'Hard Rock Cafe Hamburg' where name = 'Hamburg';
update collection set name = 'Hard Rock Cafe Hollywood on Hollywood Blvd' where name = 'Hollywood';
update collection set name = 'Hard Rock Cafe Lisbon' where name = 'Lisbon';
update collection set name = 'Hard Rock Cafe Orlando' where name = 'Orlando';
update collection set name = 'Hard Rock Cafe Paris' where name = 'Paris';
update collection set name = 'Hard Rock Cafe Prague' where name = 'Prague';
update collection set name = 'Hard Rock Cafe San Francisco' where name = 'San Francisco';

/* Multiple restaurants */
update collection set name = 'Hard Rock Cafe London' where name = 'London';
update collection set name = 'Hard Rock Cafe Miami' where name = 'Miami';
update collection set name = 'Hard Rock Cafe New York Times Square' where name = 'New York';
update collection set name = 'Hard Rock Cafe Yankee Stadium' where name = 'Yankee Stadium';
update collection set name = 'Hard Rock Cafe Changi Airport Singapore' where name = 'Singapore';

/* Multiple T-Shirts */
delete from collection where name = 'Los Angeles';
delete from collection where name = 'Miami Gardens';

/* Wrong match */
update collection set name = 'Hard Rock Cafe Angkor' where name = 'Angkor';

/* Closed restaurants */
delete from collection where name in (
    'Antwerp',
    'Boston',
    'Detroit',
    'Ho Chi Minh City',
    'Oslo'
);

commit;
