Meta Data Science interview questions

Technical interview for data scientist position. First, not really a data science position, more data analyst - huge focus on SQL. Live coding done through coderpad. The interviewer arrived late, then seemed super distracted and jaded the entire time, and you could tell they did not enjoy their job and didn't want to be giving the interview.

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