Hi Steven, Could you try indexing the result of the second 'select value count...' statement?
> use experiments > select count (country) from Tweets1; > select case when (select value count (country) from Tweets1)[0] > 50 THEN > "true" ELSE "false" END; Thanks, Vignesh > On May 15, 2017, at 5:09 PM, Steven Jacobs <[email protected]> wrote: > > Hi all, > I'm trying to understand the capabilities of the "case" that we have in > SQL++. I tried the following queries and the two results don't seem to make > sense. Am I missing something? > > SQL++: > use experiments > select count (country) from Tweets1; > select case when (select value count (country) from Tweets1) > 50 THEN > "true" ELSE "false" END; > > RESULTS: > > { "$1": 36297735 } > > { "$1": "false" } > > Thanks, > Steven
