Is there a way to create this output without using insert into and declaring anything.

Lets forget all the conditions. Lets just say that I need to print this without using...

So I saw a while back that its possible with a case statement, because once this sql code is created it goes into a another software that parses basic level...

Is there any way to do it without inserting data? with case statements? I pretty much need it to print like the above table but on the fly.

Something like this

SELECT...

So yeah, criteria meaning a condition. So if condition one is met then it would be list 1, else list 2.