Search code examples
google-bigqueryspring-cloud-gcp-bigquery

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

Solution

  • 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 ...