Statistical Summary

Combine min, percentiles, and max to show the full distribution of values.

Interactive Example

Try It

TABLE ROWS occupation * income.(min | p25 | p50 | p75 | max);

Dataset:samplesoccupation, education, gender, income

Try Variations

Query Breakdown

income.(min | p25 | p50 | p75 | max) - Multi-binding syntax showing the five-number summary
min - Minimum value
p25 - First quartile
p50 - Median
p75 - Third quartile
max - Maximum value

This "five-number summary" provides a complete picture of the data distribution in a single row.

Use Cases

Salary analysis: See the full range of salaries, not just the average
Performance metrics: Understand response time distributions (p50, p95, p99)
Quality control: Identify outliers by comparing min/max to quartiles
Comparing groups: See if distributions differ across categories

Interquartile Range - Focus on the middle 50%
Median - Simple median calculation
Multiple Aggregates - General aggregation syntax