opteryx
opteryx copied to clipboard
🪲 CASE in SELECT error
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'