Thats it!  Amazing work, and thank you so much.  I am forever in your debt.

Hi Frederico- sorry, this was my mistake.  There should be no increment on 1/07/2017 or 1/08/2017 (fixed below).  The same with the other dates you asked about.  An increment only...

Thank you so much!  I was able to run the query- however, the output is still not exactly what I am looking for.  I have attached actual vs expected- what...

Thank you Frederico- this is probably a very basic question, but how to I include the table name in the query you supplied so it knows where to pull data...

Thanks Drew- I changed to LEAD.  Attached is updated actual vs expected output.  Any insight on how to change to code to accommodate the expected output?

Thank you for your reply. I made the recommended changes, and below is the new query- the result is that every row in the Episode column is 1

            
May 4, 2020 at 3:26 pm
            
#3748678