Writing SQL Query is always fun. I have started form single Table query to double or even n number of tables. Joining table is always fun and getting data out of it is even more pleasing. There is no FOR LOOP available for SQL Server Query. But you can use While Loop to simulate the …