I want to have A, B and C from col1 summed with their corresponding values in col2. For exaple:

Assuming the input you pasted in above is in the file foo.csv:

$ sqlite3
SQLite version 3.35.3 2021-03-20 01:00:26
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table t(a,b);
sqlite> .import --skip 1 --csv 'foo.csv' t
sqlite> select a, sum(b) from t group by a;
AAA|344000
BBB|101972640
CCC|42268000

This is the poster-child use-case for aggregate functions. It's precisely why they exist.

Stephen already gave a valid good query, I'll add a note or two:

• You may also Sort the rows at the same time This should work on your DB:

SELECT col1, SUM(col2)
  FROM {your table}
 GROUP BY col1
 ORDER BY col1

• SUM() and TOTAL() both work and both add up all the non-NULL values in a group. If you think your values may contain NULLs, you can use TOTAL() which will produce a non-NULL answer (such as 0.0) even if all the values in a group is NULL. SUM() on the other hand will return NULL in that case - which may be unwanted.

SELECT col1, TOTAL(col2)
  FROM {your table}
 GROUP BY col1

• You can use any other aggregate function in the same way. Some examples:

SELECT col1, SUM(col2), COUNT(col2), AVG(col2), MIN(col2), MAX(col2)
  FROM {your table}
 GROUP BY col1

Good luck!