RetrievingSQL Amount

Hey there,

I'm struggling to retrieve the count amount of my sql query via Java.

What I wan't to do, is to show the counted amount of a row in the title.

Help is appreciated!

use SUM(count(status) and remove group by clause

I think in your query, you want to fetch the status as well

select status, count(*) from sessions 
group by status
order by status

Then for each status (Scheduled, Preparation, etc.), you can display the value based on your count corresponding to that status, e.g. {{[0] }}