State Street Interview Question

The technical interview had question on my projects then he asked a few questions on nested database queries . Interview objective was inclined more on how you solve the problem than what the solution .