Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is curr
Posted: Mon Aug 01, 2022 9:50 am
Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:
# Syntax error : Expected end of statement but got "-" at [4:11]
SELECT age -
FROM -
bigquery-public-data.noaa_gsod.gsod
WHERE -
age != 99
AND_TABLE_SUFFIX = "˜1929'
ORDER BY -
age DESC
Which table name will make the SQL statement work correctly?
A. "˜bigquery-public-data.noaa_gsod.gsod"˜
B. bigquery-public-data.noaa_gsod.gsod*
C. "˜bigquery-public-data.noaa_gsod.gsod'*
D. "˜bigquery-public-data.noaa_gsod.gsod*`
# Syntax error : Expected end of statement but got "-" at [4:11]
SELECT age -
FROM -
bigquery-public-data.noaa_gsod.gsod
WHERE -
age != 99
AND_TABLE_SUFFIX = "˜1929'
ORDER BY -
age DESC
Which table name will make the SQL statement work correctly?
A. "˜bigquery-public-data.noaa_gsod.gsod"˜
B. bigquery-public-data.noaa_gsod.gsod*
C. "˜bigquery-public-data.noaa_gsod.gsod'*
D. "˜bigquery-public-data.noaa_gsod.gsod*`