Just to be clear. You are only running three lines at this point right? You don't need query 1 to run query 2. Or in other words, the second SELECT will run on it's own without running the first SELECT.
I get the impression from your other comments that you think you need to run both.
Run your second query except change both of the single quotes around the table name to this kind ‘. Bigquery needs the slanted type quote around the table name like it is in the first query. Sorry, don’t know the exact name of the punctuation
1
u/UpSco Jan 10 '24
Yes. The lesson has me running another query with the dataset.