Citation :
Worker (Worker-ID (key), worker-name, hourly-rate, skill-type, supervisor-ID)
Building (Bldg-ID (key), bdlg-adress, type, quality-level, status)
Assignement(worker-Id(key),Bldg-ID(key), start-date,num-days)
la question :
For each supervisor managing more than one worker, list the supervisor's ID and the highest hourly wage paid to a worker reporting to this supervisor
|