I answered it based upon my logic but the only problem is that the interviewer wanted exact result which I couldn't get it because the code share website was not up and I had to iterate the SQL code to him . And he was really dumb to iterate my technical language. Petty him and the way he is working at the company. Honestly I have been senior at my company but wouldn't expect to seriously let someone being so untechnical . I don't know whether he doing it intentionally just to confuse me but that was totally unethical