SQLite Forum

order of INSERT affects the output
Login
> SQLite allows columns in an aggregate query that are not arguments to an aggregate function nor arguments to the GROUP BY clause. This is not standard SQL, and is sometimes criticized. But it does have its uses.

I don't know why there could be any criticism because imho it has absolutely no negative impact. Those who want strict SQL behavior just don't have to use it.

To me, it's one of the best (of not the best at all) variance from strict SQL that one can do. It's a great aid and not a misfeature at all. I love it! 💙