PracHub
QuestionsLearningGuidesInterview Prep

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.

  • medium
  • Rippling
  • Data Manipulation (SQL/Python)
  • Data Analyst

Build a Gap-Free Monthly Booking Summary

Company: Rippling

Role: Data Analyst

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Quick Answer: 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.

Last updated: Jul 24, 2026

Related Coding Questions

  • Find Payroll Bookings in the Latest Active Month by Country - Rippling (medium)
Loading…
PracHub

Master your tech interviews with 8,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.