How to create a service to retrieve only existing data with count?

[tgrall]

For the UI I need to create some facelets/lists that are equivalent of select id,label, count from categories.

Explain this in quarkus