Trouble returning count() with value name

I am trying to aggregate some information, but am not super familiar with Influx, let alone the language.

I have a dataset I have already filtered down:

What I would like to do is count how many instances of each lookup (DE:2,FR:1,RO:1,US:3 for this screenshot)

Whenever I uncomment count, regardless of what I count it off of, I get 1 column returned, with numbers returned, but there is no lookup column, to link the numbers to anything useful.
How can I produce useful aggregate data for the above, and keep it as one table output as well?

I was able to get it to aggregate properly, but it’s not one result set. How would I combine these into one table?

Got it. Sorry y’all