Test 3 - Quarry

SQL

USE enwiki_p;
SELECT
    u.user_count,
    COALESCE(m.male_count, 0) AS male_count,
    COALESCE(f.female_count, 0) AS female_count,
    u.user_count - COALESCE(m.male_count, 0) - COALESCE(f.female_count, 0) AS remaining_count
FROM
    (SELECT COUNT(DISTINCT user_id) AS user_count FROM user) AS u
LEFT JOIN
    (SELECT COUNT(DISTINCT up_user) AS male_count FROM user_properties WHERE up_property = 'gender' AND up_value = 'male') AS m ON 1=1
LEFT JOIN
    (SELECT COUNT(DISTINCT up_user) AS female_count FROM user_properties WHERE up_property = 'gender' AND up_value = 'female') AS f ON 1=1;
SQL

Checking query status...
