Count the number of users for each unique gender (e.g., male, female, non-binary).

SELECT user_gender, COUNT(*) AS total_users_per_gender
FROM order_transaction.transaction_detail_deprecated
GROUP BY user_gender;