此博客详细展示了如何通过SQL查询，分析定制客户的活跃任务量和已完成作品，重点关注了定制状态为1的客户，以定制ID为基础，揭示了他们的工作表现。
select c.customid,c.headurl,c.nickname,c.working_years,c.remarks,c.certificate,
t.countTask,w.countWorks
FROM custom_info c
left join (select count(custom_id) as countTask,custom_id from task_info where project_status = 3 GROUP BY custom_id) t on c.customid = t.custom_id
left join (select count(customid) as countWorks,customid from works_info where original_type = 0 and auditing_status = 1 GROUP BY customid) w on c.customid = w.customid
where custom_status = 1
ORDER BY c.customid
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
