如何查询同一行中的两个数据是否相等

我想查询列zy下同一个专业syszd与qwdwszd相同与不同的个数。请问sql语句该怎么写

SELECT u.zy,COUNT(u.zy) as '=', (SELECT COUNT(u1.zy) FROM `user` u1 WHERE u1.syszd <> u1.qwdwszd and u.zy = u1.zy) as '<>' FROM `user` u WHERE u.syszd = u.qwdwszd GROUP BY u.zy

select a.zy,count(a.syszd),b.cc from 表名 a
left join (select zy,count(1)cc, from 表名 where syszd <> qwdwszd group by zy ) b on a.zy = b.zy
where a.syszd = a.qwdwszd group by zy