updated query entity for gender report