aggregation_with_named_node.sql 244 B

12345678910
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. $data = (SELECT cast(key as Uint32) ?? 0 as key, value FROM plato.Input);
  4. $quant = 0.1;
  5. SELECT
  6. $quant * 100 as quantile,
  7. PERCENTILE(key, $quant) as key_q,
  8. COUNT(*) as count
  9. FROM $data;