count consecutive occurrences if multiple criteria

rangelsammon 

How about this online tool?

http://e.anyoupin.cn/EData/?s=basic_count_consecutive_occurences

 create temp table aa as 

select *,lag(player) over (),iif(lag(player) over ()!=player or rowid=1,rowid,'') grp from basic_count_consecutive_occurences;

create temp table bb as 

select *,fillna(grp) grp2 from aa;

select * from bb;

cli_add_html~mike,rack=1;

select grp2,player,rack,count(grp2)-1 times from bb where player like 'mike' and rack=1 group by grp2;