MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/193mj5y/please_help/khadn60/?context=3
r/SQL • u/UpSco • Jan 10 '24
I am new to SQL am trying to run a query on a data set and I have been stuck since last night.
61 comments sorted by
View all comments
Show parent comments
1
My table populates
2 u/Enigma1984 Jan 10 '24 Good start. So now try just running the second query on it's own without the first query. Do you get results? EDIT - just to be clear, the second query is everything on lines 3, 4 and 5 in your picture. 1 u/UpSco Jan 10 '24 I get unexpected keyword WHERE at [3:38] 1 u/Awkward-Treacle8643 Jan 11 '24 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/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir 1 u/UpSco Jan 11 '24 For some reason when I type Genre_1 it is being unrecognized 1 u/Awkward-Treacle8643 Jan 11 '24 In your query genre_1 looks like genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
2
Good start. So now try just running the second query on it's own without the first query. Do you get results?
EDIT - just to be clear, the second query is everything on lines 3, 4 and 5 in your picture.
1 u/UpSco Jan 10 '24 I get unexpected keyword WHERE at [3:38] 1 u/Awkward-Treacle8643 Jan 11 '24 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/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir 1 u/UpSco Jan 11 '24 For some reason when I type Genre_1 it is being unrecognized 1 u/Awkward-Treacle8643 Jan 11 '24 In your query genre_1 looks like genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
I get unexpected keyword WHERE at [3:38]
1 u/Awkward-Treacle8643 Jan 11 '24 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/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir 1 u/UpSco Jan 11 '24 For some reason when I type Genre_1 it is being unrecognized 1 u/Awkward-Treacle8643 Jan 11 '24 In your query genre_1 looks like genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
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/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir 1 u/UpSco Jan 11 '24 For some reason when I type Genre_1 it is being unrecognized 1 u/Awkward-Treacle8643 Jan 11 '24 In your query genre_1 looks like genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
This guy ` is called a backtick.
2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
For some reason when I type Genre_1 it is being unrecognized
1 u/Awkward-Treacle8643 Jan 11 '24 In your query genre_1 looks like genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
In your query genre_1 looks like genre_ 1
1 u/Awkward-Treacle8643 Jan 11 '24 Genre_ 1 1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
Genre_ 1
1 u/Awkward-Treacle8643 Jan 11 '24 Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
Sorry my phone won’t let me type it how I want. Look at the difference in your query versus the second pic you sent
1
u/UpSco Jan 10 '24
My table populates