Besides grouping by one index and sorting by a calculated value is going to file-sort or similar, and HAVING likely needing the aggregate instead of the alias, you should write in PIPE syntax and stop doing old form SQL. Less chance you screw it up. (btw, the Trino, Doris, Duckdb, and Clickhouse Datagrip/Intellij plugins from sort.dev can all run PIPE syntax on those databases)

I'm on the waiting list for the @Kia 2028 TAZuv, now with Kia Kickjets (tm)

a few new in the box ready for next purchases, since they take time to import .

@thdxr, found it

@SuperNes64PR @avianca

Not AI youtube.com/watch?v=LKG7dhMD…

if you want to speed up all agents, get the harness to present a tool for "commit my work" fricken see this every damn time with thinking between each line and 20-30 seconds just to wrap up a quick commit.

Elaine dance youtu.be/jsl3IBAsEH4?si=otoZ…

Translate this youtu.be/xOQCgj7FQoU?si=W_pm…

Another update on the @doris_apache front, I have published a SQL Transpiler plugin for @intellijidea and @datagrip that actualy verifies with the native parsers for Doris, Trino, and DuckDb. It also knows the details of most major functions and shows analysis of the different behavior expected in the transpiled SQL. plugins.jetbrains.com/plugin…

What is my AI smoking?