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?