CASE WHEN films.actor_name = music.artist_name AND earnings > 50000 THEN UPDATE films, music SET earnings = earnings * 1.5 WHEN WHERE films.actor_name = music.artist_name AND earnings <= 50000 THEN UPDATE films, music SET earnings = earnings * 1.1END CASE*********************************************************#Fixed?UPDATE films, musicSET earnings = earnings * CASE WHEN films.actor_name = music.artist_name AND earnings > 50000 THEN 1.5 CASE WHEN films.actor_name = music.artist_name AND earnings <= 50000 THEN 1.1 END CASE;