Generally to write such queries you should break down what you are saying, so:
"...inserted food name" (get the count of food name to see which is most inserted):
select foodname, count(foodname) as c from foodtable group by foodname
"fetch food name order by most inserted..." (uses the above in a compound query):
select t.foodname from
( select foodname, count(foodname) as c from foodtable group by foodname )
as t order by t.c desc
Now you can optimize this, but it's a good place to start.