Select the group max count and also its value

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

SELECT the value of MAX( COUNT( column )

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