Quick Overview

Practice PostgreSQL date logic by finding the latest active payroll-booking month and aggregating amounts by headquarters country. The task tests precise month definitions, filtering scope, joins, empty-result behavior, numeric totals, and deterministic output.

Find Payroll Bookings in the Latest Active Month by Country

Company: Rippling

Role: Data Analyst

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Practice PostgreSQL date logic by finding the latest active payroll-booking month and aggregating amounts by headquarters country. The task tests precise month definitions, filtering scope, joins, empty-result behavior, numeric totals, and deterministic output.

Loading…