Fork of
Male vs Female editors (arwiki)
by FShbib
This query is marked as a draft
This query has been published
by Hidayatsrf.
SQL
AخA
SELECT count(user_name) AS "pengguna", (SELECT count(user_name) FROM idwiki_p.user
JOIN user_properties ON up_user = user_id
WHERE up_property = 'gender' AND up_value = 'female') AS "female"
FROM idwiki_p.user
JOIN idwiki_p.user_properties ON up_user = user_id
WHERE up_property = 'gender' AND up_value = 'male'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.