题解 | 获取有奖金的员工相关信息。

select
    e.emp_no as emp_no,
    first_name,
    last_name,
    btype,
    salary,
    round((
        case
            when btype = 1 then salary*0.1
            when btype = 2 then salary*0.2
            else salary*0.3 end
        ),1) as bonus
        from
            employees as e
            inner join emp_bonus as b on e.emp_no = b.emp_no
            inner join (
                select
                    *
                from
                    salaries
                where
                    to_date = '9999-01-01'
            ) as s on b.emp_no = s.emp_no
        order by emp_no asc;