Modify Postgres database

Hello, I’m trying to make some changes in the postgres databases.
I would like to add some new tables as I’m trying to add some indicators for the results obtained with the forms.
Those indicators will have some data as a scale of results or a mark depending of the data taken from the form.
For example this consult gives a number and with that number the indicator will give a result like green if it’s more than 10, yellow if it’s from 10-5 and red if it’s less than 5
SELECT SUM(DISTINCT(people))
FROM table
where have_light = “True”

I know that kobo creates a reports so with those reports I want to configure indicators.
I would appreciate any help

Thank you,