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 Onsite rounds at Meta.

What role is this question designed for?

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

Compute this-year spend share of last-year whales

Last updated: Mar 29, 2026

Quick Overview

This question evaluates proficiency in data manipulation and analytics engineering, specifically SQL and Python skills for aggregations, joins, calendar-year time filtering, cohort identification, exclusion logic, and monthly rollups of ad spend.

easy
Meta
Data Manipulation (SQL/Python)
Data Scientist

|Home/Data Manipulation (SQL/Python)/Meta

Compute this-year spend share of last-year whales

Write your answer

Your first approved answer each day earns 20 XP.