• Use Ifnull() function to replace null values with 0.
• Use Sum() function to sum both val1 and val2 in a single expression, using Group By on source_id.

Do the following:

SELECT resource_id, SUM(IFNULL(val1, 0)) + SUM(IFNULL(val2, 0)) AS total FROM your_table GROUP BY resource_id 

• Use Ifnull() function to replace null values with 0.
• Use Sum() function to sum both val1 and val2 in a single expression, using Group By on source_id.

Do the following:

SELECT ressource_id, SUM(IFNULL(val1, 0)) + SUM(IFNULL(val2, 0)) AS total FROM your_table GROUP BY ressource_id 

• Use Ifnull() function to replace null values with 0.
• Use Sum() function to sum both val1 and val2 in a single expression, using Group By on source_id.

Do the following:

SELECT source_id, SUM(IFNULL(val1, 0)) + SUM(IFNULL(val2, 0)) AS total FROM your_table GROUP BY source_id 

• Use Ifnull() function to replace null values with 0.
• Use Sum() function to sum both val1 and val2 in a single expression, using Group By on source_id.

Do the following:

SELECT resource_id, SUM(IFNULL(val1, 0)) + SUM(IFNULL(val2, 0)) AS total FROM your_table GROUP BY resource_id