Hi @Hamzah
It is not possible to do that in KQL unfortunately, so Discover would not be able to perform an aggregation like a GROUP BY.
You need a Visualization tool like Lens or TSVB to build such table.
In Lens you can easily build it with Top values and a filter or a filtered metric as Count:
The alternative is to send an ES query with the aggregation (as the visualization tools do under the hood).