Thanks zX41zdbW - I find the query you shared easier to reason about than:
https://github.com/klausbreyer/hackernewsstats/blob/main/que...
Also:
"Elapsed: 0.140 sec, read 33.95 million rows, 1.26 GB."
140 ms is quite impressive.
https://github.com/klausbreyer/hackernewsstats/blob/main/que...
Also:
"Elapsed: 0.140 sec, read 33.95 million rows, 1.26 GB."
140 ms is quite impressive.