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

Find the monthly opening price extremes for each stock ticker.
Aggregate daily records into monthly summaries before identifying global min/max values.
Map calculated extreme values back to their corresponding formatted month labels.

What This Tests

Multi-step aggregation and grouping logic.
Rejoining summary tables to retrieve associated descriptive attributes.
Date-to-string transformation and formatting.
Handling edge cases like single-record groups or duplicate extreme values.

Common Patterns

Aggregation

Multiple Joins

String Manipulation

Test Cases

Input

-

Output

-

Expected

-