R6 alpha - dblp

SELECT aij1.Journal
FROM article_in_journal aij1, pub_article art1
WHERE art1.PubID=aij1.ArtID
GROUP BY aij1.Journal
HAVING MAX(art1.Volume) > (
    SELECT AVG(volume)
    FROM (
        SELECT art.Volume AS 'volume'
        FROM pub_article art, article_in_journal aij
        WHERE
        art.PubID = aij.ArtID
        GROUP BY aij.Journal
        HAVING MAX( art.Volume )
    ) VOLUME_PER_JOURNAL
)
--
Showing ROWS 0 - 29 ( 87 total, Query took 45.1560 sec)
 Journal
    Edit Edit   Copy Copy   DELETE DELETE   ADS
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Artificial Intellegence
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Bioinformatics
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Fuzzy Systems
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Human-Computer Interaction
    Edit Edit   Copy Copy   DELETE DELETE   Adv. IN MM
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Operations Research
    Edit Edit   Copy Copy   DELETE DELETE   Adv. Software Engineering
    Edit Edit   Copy Copy   DELETE DELETE   Ann. Pure Appl. Logic
    Edit Edit   Copy Copy   DELETE DELETE   Annals OR
    Edit Edit   Copy Copy   DELETE DELETE   Applied Comp. INT. Soft Computing
    Edit Edit   Copy Copy   DELETE DELETE   Applied Mathematics AND Computation
    Edit Edit   Copy Copy   DELETE DELETE   Archive OF Formal Proofs
    Edit Edit   Copy Copy   DELETE DELETE   Ars Comb.
    Edit Edit   Copy Copy   DELETE DELETE   Artif. Intell.
    Edit Edit   Copy Copy   DELETE DELETE   BIAA
    Edit Edit   Copy Copy   DELETE DELETE   Biological Cybernetics