HCL Technologies interview question

Basics in SQL SERVER and Advanced concepts