Data Analyst interview — SQL and case questions they asked

SQL round had: joins, group by with having, and a window function (running total). Then a case: "sales dropped 20% last month, how would you investigate?"

For the case, structure your answer: clarify the metric, segment the data (region, product, channel), form hypotheses, then say what query you'd run. They want to see structured thinking, not a magic answer.