URI 2994 Solution

-

URI 2994 - How much earn a Doctor? 


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
SELECT d.name , ROUND (t.salary, 1)
FROM doctors as d
INNER JOIN
(
    SELECT id_doctor, SUM( (hours * 150) +
    ((hours*150.0 * w.bonus) / 100.0) ) AS salary
    FROM work_shifts AS w
    INNER JOIN
    attendances AS a
    ON w.id = a.id_work_shift
    GROUP BY id_doctor
    
) AS t
ON t.id_doctor = d.id
ORDER BY t.salary desc
;

Comments

Post a Comment