Practice Bloomberg SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Identify the closing price on the final trading day for each stock every month.
Compute the month-over-month percentage growth using the prior month’s endpoint.
Exclude the first recorded month per ticker and sort results appropriately.

What This Tests

Time-series aggregation and date boundary identification.
Sequential comparison across grouped records.
Arithmetic transformations and precision handling.
Filtering based on relational availability.

Common Patterns

Aggregation

Inner Join

Window Function

Sort

Test Cases

Input

-

Output

-

Expected

-