Device Status without Timestamps
LinkedInData Scientist · Technical Screen
Last updated
This question evaluates data manipulation and behavioral analytics competencies, emphasizing aggregation, deduplication, distinct counts, and date-based filtering to measure author and viewer activity.
Table: article_views
article_id INT author_id INT viewer_id INT view_dt DATE
Count authors who have never viewed any of their own articles.
On 2024‑11‑11, how many members viewed more than one distinct article?
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.