The error says that there's a problem in your SQL text near the character ‘)’

You only have one character ‘)’ in your input SQL text. And, indeed, the error is right before that character!

In general, it's a good idea to have a command-line version of your SQL interpreter available, and paste the code you want to run into that, and see if it works, before you put it into code of some other language. That way, it's easier to tell when you get the SQL wrong, versus when you get the Python/C++/Haskell/whatever wrong.