Jeremy Taylor

Results 242 comments of Jeremy Taylor

Noting this example from Clickbench: `SELECT ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c FROM hits GROUP BY ClientIP, ClientIP - 1, ClientIP - 2,...

Metabase will do this when 'auto-binning' very routinely: ``` SELECT FLOOR(("public"."partsupp"."ps_supplycost" / 125.0)) * 125.0 AS "ps_supplycost", COUNT(*) AS "count" FROM "public"."partsupp" GROUP BY FLOOR(("public"."partsupp"."ps_supplycost" / 125.0)) * 125.0 ORDER...