LinkedIn Data Scientist interview questions

A recruiter reached out to me on LinkedIn(!) regarding DS roles. I spoke to him on the phone - standard HR round, finding best fit. I was told there will be two more phone screens - one SQL coding + another case study based. If I cleared them, next step is on-site. I spoke to one of the hiring managers in the DS team for the first coding exercise. A brief mutual intro and she said she will ask one or two SQL queries depending on time. 45 minutes was set for this. She started with a SQL question regarding LI page views data - how to gather info regarding activity of crawlers (probably not the right name, but I forget what she exactly used). I started writing the code and took almost all remaining time, but I could sense she wasn't happy with my answer. Not surprisingly, I never heard back from them :)

The process is a call with the recruiter, two phone screens and then an onsite. I'm still in the process, I just wanted to say: watch out for who you get paired with. The recruiter I spoke with was the rudest recruiter I've chatted with during any interview. Very curt.