想获取工人服务的产品单数和户数,那位给指点一下,不知道我的图片上的内容能不能说明问题!
select c_worker,count(1) as c_Num,count(distinct c_addr) as x_num from table group by c_Worker;