Fork of
ukwiki gender nums
by Antanana
This query is marked as a draft
This query has been published
by Antanana.
SQL
AخA
select IFNULL(up_value, 'not specified'), count(IFNULL(up_value, 1)) as num
from ukwiki_p.user us
left join ukwiki_p.user_properties ps
on ps.up_user = us.user_id
where (ps.up_property = 'gender' or ps.up_value is null) and us.user_editcount >= 1
group by up_value;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.