如何写一个复杂的有逼格的SQL连表统计查询语句，步骤/写法/方法/思路

一步一步来。

1.首先要查什么?

SELECT '部门','未跟进数统计数';

2.要用到哪些表？

FROM 
	kf_department AS dept
	JOIN 
	kf_clerkuser AS kf_user ON dept.ID = kf_user.BELONGDID
	JOIN
	kf_client AS kclient ON kf_user.CLERK_ID=kclient.BELONGID

3.有什么筛选条件？WHERE啊，ORDER BY啊，子查询啊，排序。

WHERE
	kclient.CLIENT_ID NOT IN(SELECT CID FROM kf_follow)

GROUP BY dept.ID

ORDER BY counts DESC

思路方法和步骤就是：分开写。

最后来一个完整的：

SELECT dept.DEPARTMENT,COUNT(1) as counts

FROM 
	kf_department AS dept
	JOIN 
	kf_clerkuser AS kf_user ON dept.ID = kf_user.BELONGDID
	JOIN
	kf_client AS kclient ON kf_user.CLERK_ID=kclient.BELONGID

WHERE
	kclient.CLIENT_ID NOT IN(SELECT CID FROM kf_follow)

GROUP BY dept.ID

ORDER BY counts DESC;

下面，上一个装逼图：