[SQL] count distinct with conditions

select
  count(distinct tag) as tag_count,
  count(distinct (case when entryId > 0 then tag end)) as positive_tag_count
from
  your_table_name;

https://stackoverflow.com/questions/14048098/count-distinct-with-conditions

COUNT DISTINCT with CONDITIONS