You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WITH produce AS (
SELECT'kale'AS item, 23AS purchases
)
SELECT item, sum(purchases)
FROM produce
GROUP BY item
QUALIFY ROW_NUMBER() OVER (PARTITION BY item ORDER BY item) =1
Expected
item
col1
kale
23
Actual
failed to query ...: near "WHERE": syntax error
The text was updated successfully, but these errors were encountered:
Related to #147
Expected
Actual
The text was updated successfully, but these errors were encountered: