An Awesome Tricky SQL Logic | Complex SQL 10
In this video we are going to learn a very nice SQL trick. here is the script:
create table tasks (
date_value date,
state varchar(10)
);
insert into tasks values ('2019-01-01','success'),('2019-01-02','success'),('2019-01-03','success'),('2019-01-04','fail')
,('2019-01-05','fail'),('2019-01-06','success')