Usind SQL Server window functions with year and month(Period of time)

Please consider this script:

Usind SQL Server window functions with year and month(Period of time)

Please consider this script:

Usind SQL Server window functions with year and month(Period of time)

Please consider this script:

Select first column for multiple occurrences of second column and a condition from third column

I have a table which looks like this

SQL Select first column for multiple occurrences of second column and a condition from third column

I have a table which looks like this