how do i learn sql

the language is so terrible and inconsistent. I want to stab out my eyes just reading it. How do I force myself to read the entire thing without having a nervous break down and come to after implementing a full replacement in lisp?

>>36
There isn't inconsistency in the spec. The problem is the spec is too large.

What is the intuition behind this?


select NULL in () -> 0
select NULL in (7) -> NULL
select 7 in (7, NULL) -> 1

If NULL is meaningless, why should `NULL in ()' be meaningful? Why is (7, NULL) meaningful? There are rules that outline the results of these cases, but the rules are at too high of a level. If the rules were smaller, there would be an explanation for the results above, rather than a definition. And the explanation might make sense to someone, as opposed to memorization of that's just what sql does.