Finding greatest count of each distinct column value

Viewed 198

Given a table like below, is it possible in Kusto get the row with the greatest count for each food?

Person Food NumEaten

a   cake    28
b   cake    6
c   cake    3
d   cake    2
e   cake    2
f   pie     117
g   pie     79
h   pie     41
i   pie     35

Result to achieve:

Person  Food    NumEaten

a   cake    28
f   pie     117
1 Answers
Related