mysql group by
SELECT 'not_distinct' a, count(*) cnt,val FROM analysis_debug
group by val
union all
SELECT 'distinct' a, count(distinct(user_id)) cnt,val FROM analysis_debug
group by val
union all
SELECT 'not_distinct-2' a, count(user_id) cnt,val FROM analysis_debug
group by val