select 

    coalesce(up.up_value, '-') as gender,

    count(*) as count

  from

    user u 

    left outer join user_properties up on up.up_user = u.user_id and up.up_property = 'gender'

  group by

    up.up_value

  order by

    count desc

    ;