As the error message says:
It expected only one ”(“ in the query expression.

You may want to change the key word as well:
This looks like Google Sheets’ QUERY function (not related to MS PowerQuery)

It supports some basic SQL query but not all. Especially, nested query is not supported. And the FROM clause has been eliminated from the language as well.

Feel free to check for more details here: https://support.google.com/docs/answer/3093343?hl=en