Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product

SQL++
1

Hello,

How can I fix this error ?

Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product

SELECT 

p.name,
p.unitPrice

FROM product p

WHERE price > (
    SELECT avg(p.unitPrice) FROM product
)
2

You can’t fix this. This not supported version you using. You must use higher version.
Not sure what is meaning of query. In correlated subquery required secondary index.