Lots of questions ranging from basic SQL to advanced sql. Sample questions were like how do you write a macro in SAS/SQl. Another one was about window functions like partition and difference between rank and dense rank etc