Test 3 - Quarry

SQL

USE ckbwiki_p;
SELECT
    user_count,
    COALESCE(male_count, 0) AS male_count,
    COALESCE(female_count, 0) AS female_count,
    user_count - COALESCE(male_count, 0) - COALESCE(female_count, 0) AS remaining_count
FROM (
    SELECT
        COUNT(DISTINCT user_id) AS user_count,
        (SELECT COUNT(DISTINCT up_user) FROM user_properties WHERE up_property = 'gender' AND up_value = 'male') AS male_count,
        (SELECT COUNT(DISTINCT up_user) FROM user_properties WHERE up_property = 'gender' AND up_value = 'female') AS female_count
    FROM user
) AS counts;
SQL

Checking query status...
