select staff_id,
staff_name,
concat(round((dock_salary) / (normal_salary) * 100, 1), '%') as dock_ratio
from staff_tb st
join salary_tb using (staff_id)
where st.department = 'dep1'
order by dock_ratio desc

select staff_id,
staff_name,
concat(round((dock_salary) / (normal_salary) * 100, 1), '%') as dock_ratio
from staff_tb st
join salary_tb using (staff_id)
where st.department = 'dep1'
order by dock_ratio desc