使用group by 去重

select count(distinct(column1)) 
from 表名 
where column3=20210611;      

select 
 column1,
 count(1)
from 
表名 
where 
 column3=20210611
group by 
 column1;