Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
not an issue
If you look to the right of SQL it announces it's using PostgreSQL's "PL/SQL", not Oracle's (I was going crazy till I noticed).
I have no idea yet of PostgreSQL but I found this:
https://www.postgresqltutorial.com/dollar-quoted-string-constants/
Using dollar-quoted string constant in anonymous blocks
The code in the block must be surrounded by single quotes (...)
To avoid escaping every single quotes and backslashes, you can use the dollar-quoted string (...)
Same applies to our case: "Using dollar-quoted string constants in functions"
This comment is hidden because it contains spoiler information about the solution
also, you are supposed to write a select statement, yes.
I'm sorry, but I don't know enough SQL to help.
Maybe someone else better at sql can answer?