Untitled query #53060

SQL

use dewiki_p;
select up_value, count(*) as 'deusers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use enwiki_p;
select up_value, count(*) as 'enusers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use frwiki_p;
select up_value, count(*) as 'frusers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use jawiki_p;
select up_value, count(*) as 'jausers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use itwiki_p;
select up_value, count(*) as 'itusers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use fiwiki_p;
select up_value, count(*) as 'fiusers by gender' from user_properties
where up_property = 'gender'
group by up_value;

use svwiki_p;
select up_value, count(*) as 'swusers by gender' from user_properties
where up_property = 'gender'
group by up_value;
SQL

Checking query status...
