Fork of
Gender by user groups in ptwiki
by HenriqueCrang
This query is marked as a draft
This query has been published
by HenriqueCrang.
SQL
x
use dewiki_p;select ug_group, gender, count(*) from ( select ug_group, if(up_value IS NULL ,"none",up_value) as gender from (select ug_user, ug_group from user_groups) a left outer join (select up_user, up_value from user_properties where up_property = "gender") b on ug_user = up_user ) x group by ug_group, gender;
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.