Array to HTML "Table"

Hi,

Is it possible to calculate this in the database? I've tried so many queries but without the result I want because SQL is not my expertise...
Or I've to re-write my script because right now it's working but the code is bad.

Suggestions?

I did not see what database you are using.  It appears you can use IF statements in mSQL SQL statements though.

https://www.geeksforgeeks.org/mysql-if-function/