WITH lep_find As
(
SELECT date, admin_level_1, tests_total, tests_increase FROM 'YourDB' GROUP BY date,admin_level_1, tests_total, tests_increase LIMIT 1000
),
Total as (
SELECT lep_find.tests_total, lep_find.tests_increase, Sum (lep_find.tests_total+lep_find.tests_increase)AS total_count FROM lep_find
) Select *from lep_find
I have written the code and I want to show all the Raw with Existing/New Column in the database