On page 4 of "A Critique of Modern SQL And A Proposal Towards A Simple and
Expressive Query Language" [0] (recently published at CIDR 2024) there's a great diagram covering this and many other "semantical ordering" confusions with SQL. It's an interesting paper in general, by a couple of the biggest names in modern database research (...though admittedly perhaps not language design).
Something like 'SaneQL' (which the paper introduces) deserves to succeed outside of the lab. Source is here [1].