Why do I keep getting this Syntax Error in BigQuery

Question

I keep getting this syntax error: Syntax error: SELECT list must not be empty at [2:3]

on my SQL query: Select
FROM 'tfdalissabuck.assessment_01.experiment' WHERE experiment_cohort = 'treatment' AND minutes_listening_during_experiment > '60'

Daniel Zagales · Accepted Answer · 2021-08-25 13:25:31Z

2

You need something between SELECT AND FROM, a single or multiple column names. Also I believe you are using single quotes around the table name, you should be using a tick mark, and if minutes_listening_during_experiment is an integer you can remove the quotes around it

SELECT *
FROM `tfdalissabuck.assessment_01.experiment`
WHERE experiment_cohort = 'treatment' 
AND minutes_listening_during_experiment > 60

answered Aug 25, 2021 at 13:25

Daniel Zagales

3,0722 gold badges8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why do I keep getting this Syntax Error in BigQuery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related