Need to Help query in sql server

Transact-SQL
,
2

It look like a sequel of this, this and this.