所以我有类似的请求

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 在这个位置上的输入无效”error_picture。你能帮我理解这段代码有什么问题吗？