Meta Data Scientist interview questions

I went through the campus recruiting and pass the HR round. HR round is pretty smooth, only general BQ questions and couple simple coding questions. It tooks 2 weeks to move to the next round. The coding round is difficult and require high-level sql skills. I cannot solve immediately

A recruiter reached out asking if I would be interested in interviewing. An initial screening call was simply to cover my background, what I was looking for and some skill sets. They asked some behavioural questions and basic technical questions. My answers seemed to go into more depth as she noted that she didnt need to cover the sql questions she normally asks. The next stage was an hour interview with an existing senior data scientist. He was friendly but we seemed to be speaking at cross purposes. His English was not perfect and his background seemed to be from software engineering so perhaps it was destined to be more difficult than it might have been. He pushed hard in a certain direction, then claimed I was going too deep. Finally, ten minutes later he came back and touched once again on the topic which confused me. Clearly he was not satisfied but he didnt reframe his question and when prompted to clarify just said "what do you think?". Had I gone too deep or had I not addressed the issue enough? Despite this, he was very friendly and was eager to answer and address any question or concern if only answering superficially. A boiler plate one line rejection email followed. No feedback is offered as a policy. However, arrogantly they solicit candidates to give them feedback. Yet more time demanded entirely for Facebooks benefit.