Lovely interview team. You get to meet analysts at different levels which is great for asking questions. SQL test is reasonably difficult, but at the very least you should comment your approach to each problem (pseudocode).
Interview questions [1]
Question 1
The questions are trying to find out if you think like an analyst. Specific knowledge about the sector is not necessarily required.
