SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but …