Which table name will make the SQL statement work correctly?

Your company is using WHILECARD 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*`

Answer: D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments