R5

SELECT DISTINCT pa1.AuthorName
FROM Pub_author pa1, Article_in_Journal j
WHERE pa1.PubID
IN (
SELECT art.PubID
FROM Pub_Article art
)
AND j.ArtID = pa1.PubID
GROUP BY pa1.AuthorName
HAVING MAX(j.Journal)
LIMIT 5

C'est de la merde. Ça n'a aucun sens de faire un MAX(j.Journal)