I have a table date, store code, do_no. some stores have missing sequence number. Data looks like Source. I’m not able to find missing doc_no in all stores. Each store doc_no start digit is different. STO1 starts wth 1, ST02 start with 2,ST03 3 etc..

I’m expecting results to find which store have missing doc_no. example expected results. Expected Results