With SQL, there are many different ways to write a query and to get the correct result returned to you. Instead of "1+1=2" being the only answer, it'd be more like: "1+1=2", "2+0=2", and "0+2=2". All are correct.
In my experience on SO with both SQL and Python, there are usually a number of correct answers for every question. How correct it is depends on things that usually aren't in the question: size of the data set, dependencies or processes that may break as a result of answer, etc.
In my experience on SO with both SQL and Python, there are usually a number of correct answers for every question. How correct it is depends on things that usually aren't in the question: size of the data set, dependencies or processes that may break as a result of answer, etc.