Lab07-Query2

SELECT AV.agenumero, ageNombre, total
    FROM vmventas2000_15 AV, dimagentes15 DA
    WHERE DA.ageNumero = AV.ageNumero AND
    region = 7 AND
    total =
        (SELECT MAX(total) FROM vmventas2000_15 WHERE
            region = 7 AND
            mes = (SELECT mes FROM vmventas2000b_15
                     WHERE totalmes =
                        (SELECT MAX(totalmes) FROM vmventas2000b_15 WHERE region = 7)));