PracHub
QuestionsPremiumLearningGuidesCheatsheetNEWCareers

Quick Overview

This question evaluates data manipulation and behavioral analytics competencies, emphasizing aggregation, deduplication, distinct counts, and date-based filtering to measure author and viewer activity.

  • Medium
  • LinkedIn
  • Data Manipulation (SQL/Python)
  • Data Scientist

Device Status without Timestamps

Company: LinkedIn

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: Medium

Interview Round: Technical Screen

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?

Quick Answer: This question evaluates data manipulation and behavioral analytics competencies, emphasizing aggregation, deduplication, distinct counts, and date-based filtering to measure author and viewer activity.

Last updated: Mar 29, 2026

Loading coding console...

PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • Careers
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.

Related Coding Questions

  • Write SQL for rankings, state, and aggregations - LinkedIn (easy)
  • Analyze member video posting behavior by country - LinkedIn (easy)
  • Compute article-type diversity per user and histogram - LinkedIn (easy)
  • Compute each member’s current notification status - LinkedIn (easy)
  • Find top countries by population per continent - LinkedIn (easy)