I can’t wrap my head around how this should work. Given below tables:

Articles:

Article codes:

Desired output:

I would like to select the count of the most frequent code per group, as well as the actual code to go along with it. But I can’t figure out how to select the actual code (column “code”).
I’m fine with ties returning whichever value of the tied code.

Below query returns class and max_group but without the code value.

SELECT 
  DISTINCT  articles.class,
  MAX( COUNT( article_codes.code ) ) OVER( PARTITION BY class ORDER BY class ) AS group_max         
        
FROM articles
  INNER JOIN "/WHA/article_codes" As article_codes ON articles.article_no = article_codes.article_no
        
  GROUP BY class, code
  ORDER BY group_max DESC;

Result:

Desired result: