I have 2 table and I wanna a query with 3 column result

in on of them 2 column with view count and title name and in the other 1 column with type_ and i wanna to grouping type_ with max(view count) and show the them title

but i didn't have any idea about grouping expression.

i think we can solve in by using sub query but i don't know which column use in group by.

2 table join with this expression class pk=resource key

i exam this query:

SELECT t.title,j.type_ FROM tags asset t,journal article j
where type_ in (select type_
from journal article,tags asset where class pk=resource  key
group by type_)

but the answer was wrong