SELECT count( r.id_receta ) total, sum( if( p.sexo = 'M', 1, 0 ) ) M FROM receta r INNER JOIN persona p ON r.id_expediente = p.id_expediente