Sample create and insert as below -
create table t1(date_column string, c1 int, c2 int, c3 int, c4 int, c5 int);
insert into t1 values("d1",1,1,1,1,1);
insert into t1 (date_column,c1) values ("d1",1);
insert into t1 (date_column,c1) values ("d2",1);
insert into t1 values("d2",1,1,1,1,1);
I was expecting the below query to return 0 for d1 and d2, unfortunately got an empty result set.
select count(*) from t1 where c1 is null group by date_column;
... View more
