SET @start_date = '20230101000000';

SET @end_date = '202312312359000';

​

SELECT

  COUNT(log_actor) AS total,

  COUNT(CASE WHEN (up_property = "gender" AND up_value = "female") THEN up_user END) AS gender_female,

  COUNT(CASE WHEN (up_property = "gender" AND up_value = "male") THEN up_user END) AS gender_male

FROM

  elwiki_p.user_properties p

JOIN 

  elwiki_p.logging l

ON 

  up_user = log_actor

WHERE

  `log_type` = 'newusers' 

AND

  `log_action` = 'create'

AND

  `log_timestamp` BETWEEN @start_date AND @end_date;