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