select pay_ability ,concat(round((100*overid_num/total_num),1),"%") overdue_ratio from( select pay_ability ,count(overdue_days) as overid_num ,count(*) as total_num from customer_tb c left join loan_tb l on c.customer_id=l.customer_id group by pay_ability) as num order by overdue_ratio des...

select post ,round(avg(worktime),3) work_hours FROM( select post ,round(TIMESTAMPDIFF(minute,first_clockin,last_clockin)/60,3) as worktime from attendent_tb a join staff_tb s on a.staff_id = s.staff_id ) as wk group by post order by work_hours desc

select round(avg(distinct score),3) avg_acore from recommend_tb r join user_action_tb u on r.rec_user = u.user_id and rec_info_l = hobby_l # 注意要加上distinct

select user_id,c.room_id,room_type,datediff(checkout_time,checkin_time) daysfrom checkin_tb c left join guestroom_tb g on c.room_id = g.room_idwhere checkin_time >= '2022-06-12' and datediff(checkout_time,checkin_time) > 1order by user_id