SQL is an awfully-designed language and has WATs coming out of its eyeballs. Two things (out of many) off the top of my head: 1. Every subselect must be given

SQL is an awfully-designed language and has WATs coming out of its eyeballs. Two things (out of many) off the top of my head: 1. Every subselect must be given a name, even if you never use that name. 2. This orders by the second column SELECT * from table ORDER BY 2; whereas this orders by the constant 1 + 1, i.e. 2. SELECT * from table ORDER BY 1 + 1;