Test 3 - Quarry

SQL

USE ckbwiki_p;
SELECT
    COUNT(DISTINCT u.user_id) AS user_count,
    COUNT(DISTINCT CASE WHEN up.up_property = 'gender' AND up.up_value = 'male' THEN up.up_user END) AS male_count,
    COUNT(DISTINCT CASE WHEN up.up_property = 'gender' AND up.up_value = 'female' THEN up.up_user END) AS female_count,
    COUNT(DISTINCT u.user_id) - COUNT(DISTINCT CASE WHEN up.up_property = 'gender' AND up.up_value IN ('male', 'female') THEN up.up_user END) AS remaining_count
FROM
    user u
LEFT JOIN
    user_properties up ON u.user_id = up.up_user;
SQL

Checking query status...
