0
WHILE (SELECT AVG(unit_price) FROM Products) < 30 
BEGIN
    DELETE FROM Products
    WHERE UnitPrice = MAX(UnitPrice)
    IF ( SELECT MAX(UnitPrice) FROM Products ) < 50 
        BREAK
END

We need to convert Sybase SQL query to snowflake sql query. Now above query need to be converted as snowflake sql.

0 Answers0