18“NOT” and “AND” Problems
“For every complex problem, there’s an answer that is clear, simple, and wrong.”
—H. L. MENCKEN
Topics Covered in This Chapter
At this point (especially if you’ve been a good student and have worked through all the sample statements and problems), you should be very comfortable with the basics of the SQL database language. Now, in the words of a famous Louisiana chef, it’s time to “kick it up a notch.” In this chapter, I’m going to walk you through more complex problems to find out when something “is not” and when something “is” under multiple conditions. In Chapter 19, “Condition ...