Write SQL for rankings, state, and aggregations

Quick Overview

This question evaluates a candidate's competency in SQL data manipulation, covering ranking/top-N queries, aggregations and percentage calculations, temporal state reconstruction from action logs, and detection of first-occurrence events.

Write SQL for rankings, state, and aggregations

Company: LinkedIn

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Quick Answer: This question evaluates a candidate's competency in SQL data manipulation, covering ranking/top-N queries, aggregations and percentage calculations, temporal state reconstruction from action logs, and detection of first-occurrence events.

|Home/Data Manipulation (SQL/Python)/LinkedIn
LinkedIn logo
LinkedIn
Feb 21, 2026, 8:52 AM
easyData ScientistTechnical ScreenData Manipulation (SQL/Python)
7
0
PracticeRead
Loading...
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)