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.