Yes, it works without the EXISTS clause, but the problem is that I need to create CTEs, which are not supported on OAS Desktop. Also what's the alternatives forEXISTS clause in OAS?

also exists clause is not supported in OAS, and need to run query that uses exists clause so what's the alternative on Oracle analytics server?

Actually have this sample query where there is no database needed b/c here create some dummy data and it causes this error " Unsupported SQL statements." The query is: : -- Step 1: Create CTEs with Dummy Data WITH Products AS ( SELECT 1 AS ProductID, 'Laptop' AS ProductName, 'Electronics' AS Category, 1000 AS Price, 50 AS…