Question

Musician (mus_name, mus_place, mus_town)

mus_name (PK) = musician’s name (assume the maestro is a musician and thus his name also appears in this table)

mus_place = musician's place

mus_town = town in which the musician or maestro lives.

Orchestra (mus_name, orch_name, mus_pay)

mus_name(PK) = musician’s name (assume maestro is a musician the and thus his name also appears in this table)

orch_name = name of orchestra to which musician or maestro belongs

mus_comp = compensation of applicable musician or maestro

OrchInfo(orch_name, orch_loc)

orch_name(PK) = name of orchestra to musician or which maestro belongs

orch_loc = location in which the orchestra resides.

Maestro(mus_name, maestro_nom)

mus_name(PK) =musician’s name (assume the maestro is a musician and thus his name also appears in this table)

maestro_nom = name of musician’s maestro(remember: maestro name has an entry in the musician table)

List all musicians (by name) who have larger compensation (mus_pay) than their associated maestro. Display mus_name, mus_place (for musician not mestro), mus_comp, maestro_nom, and corresponding compensation of maestro. ASSUME THERE ARE NO DUPLICATE NAMES AND THAT THE DATA IS “CLEAN”.

Answer 1