Stubhub Software Engineer
Interview Questions & Guide 2026

def merge_seat_ranges(ranges):
    clean = []
    for start, end in ranges:
        if not isinstance(start, int) or not isinstance(end, int) or start < 1 or end < start:
            raise ValueError("invalid seat range")
        clean.append((start, end))
    clean.sort()
    merged = []
    for start, end in clean:
        if merged and start <= merged[-1][1] + 1:
            merged[-1] = (merged[-1][0], max(merged[-1][1], end))
        else:
            merged.append((start, end))
    return merged

Scroll sideways to view long lines.

CREATE TABLE orders (order_id TEXT PRIMARY KEY, sold_cents INTEGER, state TEXT);
CREATE TABLE payouts (order_id TEXT, payout_cents INTEGER);
INSERT INTO orders VALUES ('o1',10000,'completed'),('o2',6000,'completed'),('o3',5000,'pending');
INSERT INTO payouts VALUES ('o1',4000),('o1',5000);
WITH paid AS (SELECT order_id,SUM(payout_cents) AS cents FROM payouts GROUP BY order_id)
SELECT o.order_id,o.sold_cents,COALESCE(p.cents,0)
FROM orders o LEFT JOIN paid p ON p.order_id=o.order_id
WHERE o.state='completed' ORDER BY o.order_id;

Scroll sideways to view long lines.