MySQL WITH AS用法

WITH CountrySales AS (
    SELECT S.Country, SUM(P.Price) AS Money
    FROM OrderDetails AS D
    LEFT JOIN Orders AS O ON D.OrderID = O.OrderID
    LEFT JOIN Products AS P ON P.ProductID = D.ProductID
    LEFT JOIN Suppliers AS S ON S.SupplierID = P.SupplierID
    GROUP BY S.Country
)
SELECT Country, Money
FROM CountrySales
WHERE Money > (
    SELECT 0.3 * MAX(Money) 
    FROM CountrySales
) AND Money < (
    SELECT 0.4 * MAX(Money) 
    FROM CountrySales
)
ORDER BY Money DESC;