This chapter has shown how simple commands can be enhanced using features like DISTINCT, CASE, and complex WHERE clauses. These features give users great control over the execution of queries. They were chosen by committees as important features that should be in all SQL databases. Although you may never use all of the features mentioned in this chapter, many of them will prove valuable when solving real-world problems.