No Column Name Was Specified For Column

Using the query below in MySQL and it works. However, in MSSQL it is giving me the error message: “No column name was specified for column 3 of ‘mr1’.” The column “col” does not exist as such but is filled in the subqueries.

Can you please help me out? What am I doing wrong here?