Test 3 - Quarry

SQL

USE ckbwiki_p;
SELECT
    COUNT(DISTINCT user.user_id) AS user_count,
    SUM(user_properties.up_value = 'male') AS male_count,
    SUM(user_properties.up_value = 'female') AS female_count,
    COUNT(DISTINCT user.user_id) - SUM(user_properties.up_value IN ('male', 'female')) AS remaining_count
FROM
    user
LEFT JOIN
    (
        SELECT DISTINCT up_user
        FROM user_properties
        WHERE up_property = 'gender'
    ) AS gender_info ON user.user_id = gender_info.up_user
LEFT JOIN
    user_properties ON user.user_id = user_properties.up_user AND user_properties.up_property = 'gender';
SQL

Checking query status...
