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
