19How do you compute percentiles, medians, and quantile buckets in SQL?▼mediumMetaAmazonSnowflake2 replies○ sign inMeans mislead on skewed data like latency and spend, and SQL ships dedicated functions for the truth. The signal is PERCENTILE_CONT/DISC for exact quantiles, NTILE for bucketing, and why p50/p99 beat the average.Open full answer →
40Bin a continuous feature into quantile and fixed-width buckets in SQL. When do you use each?▼mediumAmazonMetaCapital One1 replies◆ premiumBucketing converts a skewed continuous feature into something a model (or a report) handles well, and the choice between equal-width and equal-count bins changes everything on skewed data. Here is both in SQL.Open full answer →
