题解 | SQLW21 统计员工薪资扣除比例

with t1 AS (
    SELECT
        a.staff_id,
        b.staff_name,
        ROUND(
            100 * a.dock_salary / a.normal_salary
        ,1)
             AS dock_ratio
    FROM salary_tb a
    LEFT JOIN staff_tb b
    ON a.staff_id = b.staff_id
    WHERE b.department = 'dep1'
    ORDER BY dock_ratio DESC
)
SELECT staff_id,
       staff_name,
       CONCAT(dock_ratio,'%') AS dock_ratio
FROM t1;

# 这道题还是比较简单的