@alrz it seems your SQL syntax is still invalid:
- if you have several SQL statements in one node you will have to separate them by ; (semicolon) and activate the support in the node
- make sure you qualify the table you want to access in a correct way. You have several schemas
- as has been said different databases have slightly different SQL styles with quotation marks and so on. You will have to match that
- you can use knime specific DB nodes or you can write the code yourself but this will have to be on point
Then it might help to maybe toy around with some examples to get a better grip on the use of databases