So I’m currently applying for a more senior Data Analyst positions and i wanted to know what to expect in terms of SQL interview questions.
If you are actually a senior level person, one would expect that you should be aware of a typical situation you may have encountered, and what solutions you may have applied. "Data Analysist" can encompass a pretty broad set of skills. If, in one example, a position may require coding in the R language. You are not going to be able to study a cheat sheet and be able to pass the interview.
what’s the typical style? Is it take home usually? Using a laptop? Or straight up old school annotation on paper?
What do you mean by "style"? Would you be expecting a technical exam? A verbal exam? I think the bulk of the interviews would be describing a situation, problem, and desired outcome. You would be expected to provide what you would to to understand the situation, solve the problem, and achieve the desired solution.
I rarely consider the efficiency of the query unless it’s super slow.
If you make that kind of statement in an interview for a SENIOR level position, expect a lot of rejection.