Practice TikTok SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Combine campaign metadata with performance metrics to derive key advertising KPIs.
Calculate inclusive date ranges to determine total budgeted spend accurately.
Compute derived ratios with safe division logic and strict precision requirements.

What This Tests

Preserving primary records during multi-table joins
Group-level aggregation and metric derivation
Inclusive date arithmetic and financial calculations
Safe division and controlled rounding behavior

Common Patterns

Left Join

Aggregation

Date Arithmetic

Transform

Test Cases

Input

-

Output

-

Expected

-