[Analytics] Summarise results based on 2 columns

Insights
1

Hi,
We are capturing custom analytics in the following format:

rating_given_1 rating_given_2 rating_given_3 rating_given_4 rating_given_5
0 0 0 0 1
0 0 0 1 0
0 1 0 0 0
0 0 1 0 0
1 0 0 0 0

Is it possible to sumarise the results in the following format (without capturing any additional data):

sum_rating_given_1_or_2_or_3 sum_rating_given_4_or_5
3 2
2

In the above shown table, the values are spread across different columns and currently we can’t write SQL queries on custom tables.

In addition to the above if the rating is captured in another single column, then we can filter the values less than 3 and greater than 3.