Query the database with merging records

Hello

In the database the data is stored as a table:

How to create a query in Wappler, so that the output is formed according to the condition - if the records have the same names field 1 and field 2, the records are combined into one, and the values of the fields with the number of units are added. It looks like this:

Strongly do not scold. So far I am weak in working with the database.

Thanks in advance for help.