What I expected to happen:
It should be run and create an output
What actually happened:
File "<ipython-input-7-7e642617a407>", line 1
SyntaxError: invalid syntax
I followed the instruction but confused why it turn out an error, could anyone please explain?
You have to add a white space between
The instructions clarify this -
To run SQL queries in this project, we add
%%sql on its own line to the start of our query. So to execute the query above, we’ll use the following code:
So, you need to run your statements with
%%sql and not with
%%capture at the top of the cell.
The following should run without issues -
Please note that you will have to run the queries in separate cells as well.
Thanks so much, I see the issue now.