Quick Overview

Build a PostgreSQL monthly report that fills missing calendar periods for each product and booking type. Practice distinct-customer counts, cumulative totals, prior-month comparisons, zero-denominator handling, window semantics, and stable ordering.

Build a Gap-Free Monthly Booking Summary

Company: Rippling

Role: Data Analyst

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Build a PostgreSQL monthly report that fills missing calendar periods for each product and booking type. Practice distinct-customer counts, cumulative totals, prior-month comparisons, zero-denominator handling, window semantics, and stable ordering.

Loading…