opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

🪲 CASE in SELECT error

Open joocer opened this issue 8 months ago • 0 comments
trafficstars

SELECT Company, Rocket, COUNT(*) AS NumMissions, CASE WHEN COUNT(*) > 10 THEN 'Frequent' ELSE 'Rare' END FROM $missions GROUP BY ALL; -- CASE statement with GROUP BY ALL  

KeyError: 'Field "*_count" exists 2 times in schema'

joocer avatar Feb 28 '25 17:02 joocer