sql查询，一季服用超过1个品种的总人数

Question

我有一个名为农民数据的表，它具有农民姓名、父亲姓名、农药、裁剪品种等属性(查询时需要这些属性)。

我必须为以下内容编写查询:

Total no of people who has taken more than 1 variety of crop in a Season.

我该如何编写这个查询？我试过这个查询，但它没有给我一个单一的答案。

select Farmer Name, Count(variety Of Crop) 
from farmer data 
group by farmer Name 
having count(Variety Of Crop)>1

Answer 1

你能试试这个吗？

select count(*) 
from (select 1 as y 
     from farmer data 
     group by farmer Name 
     having count(distinct Variety Of Crop)>1) x