ServiceNow Interview Question

1. SQL Top N analysis (in all technical rounds). 2. SQL Lead/Lag application (which I tried without using the functions but apparently interviewer just needed the function name) 3. Mid level join queries.