Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Grouping by expressions of type STRUCT is not allowed at [18:10]

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

 
0 1 7,060
1 REPLY 1