Exam4Training

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

Exit mobile version