Then a result set for a table was given to me and a nested query for d same was asked to write. This was end of d interview, thankfully I was able to answer all of them