I'm using Sequel Pro on a Mac and have a table like this:
Table1
a b
Blah 5
Blah 5
Smoog 5
Choop 7
Choop 7
Choop 7
Smap 7
Smap 7
Tweep 11
Tweep 11
Florg 11
And I'm running this query:
Select "MOST FREQUENT OCCURRENCE"(a), b
From Table1
Group by b
What would be the operator I put in for the "MOST FREQUENT OCCURRENCE" part? Basically what I am trying to do is figure out which "a" occurs most often with each "b". The output should look like:
"MOST FREQUENT OCCURRENCE"(a) b
Blah 5
Choop 7
Tweep 11
Thank you!