The interviewer asked me questions about:
1. The assignment asked us to use SQL and in the interview, he asked me "why don't u use R" ?
2. My sql is absolutely right, and he asked me to explain every sentence in the assignment, and he asked "why do yo use this SQL sentence instead of another SQL sentence?"
For me, analyst is a tool to give us more insights about the product.
The way he interviewed me is more like: why do you use this tool in A way instead of B way?
Imaging you get into his team and he is judging your code only because you don't write the exact same code as he did.
Very ridiculous and unprofessional interview.