CODEWITHSUNDEEP
google-bigqueryspring-cloud-gcp-bigquery
Ravenz Boomer
Ravenz Boomer

Reputation: 3

SyntaxError when adding and subtracting with BigQuery

When executing this basic query I have this error:

 WITH CALCULO AS (
   (SELECT SUM(UTILITY) FROM _coste_rv) - (SUM(UTILITY) + (SELECT SUM(UTILITY) FROM _tmp_coste)))

Message of Error:

Syntax error: Expected ")" but got "-"

What I want it to show is the amount of those 2 values

Upvotes: 0

Views: 53

Answers (1)

Michael Entin
Michael Entin

Reputation: 7724

The top-level statement should be SELECT. I.e. you cannot write

WITH Calculo AS (
   foo - bar
)

it should be

WITH Calculo AS (
   SELECT foo - bar as some_name
)

i.e.

WITH CALCULO AS (
  SELECT 
    (SELECT SUM(UTILITY) FROM _coste_rv) - 
    (SUM(UTILITY) + (SELECT SUM(UTILITY) FROM _tmp_coste))
        AS some_name
) 
SELECT ...

Upvotes: 0

Related Questions