Query Run
SELECT substr(log_timestamp,1,4),up_value AS gender FROM logging,user_properties 1 week ago
SELECT substr(log_timestamp,1,4),up_value AS gender FROM logging,user_properties 1 week ago
SELECT substr(log_timestamp,1,4) FROM logging 1 week ago