所以我有一个类似的请求
WITH customers_in_usa AS (
SELECT
customerName, state
FROM
customers
WHERE
country = 'USA'
) SELECT
customerName
FROM
customers_in_usa
WHERE
state = 'CA'
ORDER BY customerName;
但是当我写的时候,我遇到了一个错误:“'WITH is not valid input in this position'”error_picture。你能帮我理解一下这段代码有什么问题吗?