LinkedIn·Data Scientist·Technical Phone Screen
May 2026
SQL-heavy screen for a Data Scientist role at LinkedIn. Two questions, both off the same table, both requiring you to think carefully about self-joins and date filtering. Pretty focused session, no fluff.
- Using the article_views table, write a query to count how many authors have never viewed any of their own articles.
- On a specific date, how many members viewed more than one distinct article? Write the SQL to find this count.
“This one tripped me up for a second because the table uses both author_id and viewer_id and you have to compare them.” The rest of the author's notes on Data Scientist interview at LinkedIn, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post