How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

What difficulty level is this interview question?

This is a easy difficulty Data Manipulation (SQL/Python) question, commonly asked during Technical Screen rounds at LinkedIn.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at LinkedIn during technical interviews.

Analyze member video posting behavior by country

Last updated: Mar 29, 2026

Quick Overview

This question evaluates a data scientist's data manipulation skills, covering SQL/Python competencies such as joins, aggregations, deduplication, tie-breaking for first-event identification, and group-level filtering by country.

Feb 1, 2026, 5:10 AM

Data Scientist

Technical Screen

Data Manipulation (SQL/Python)

You are given member profile data and video posting events.

Tables

members

memberid INT (PK)
country VARCHAR
join_date DATE

video_posts

post_date DATE
memberid INT (FK → members.memberid )
video_length INT — seconds

Assumptions:

A member may post multiple videos on different dates.

Tasks

A) How many members posted their first-ever video on the same calendar day they joined?

Output: a single row with members_first_video_same_day .

C) For each country, how many distinct members have posted at least one video longer than 60 seconds?

Output columns: country , num_members_over_60s .

Notes

For “first-ever video”, define the first post as the minimum post_date per member; break ties using the smallest video_length (or state an alternative tie-break).

Comments (0)

Loading comments...

Browse More Questions

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