• Combining Conditions when AND Has Precedence
• Combining Conditions when OR Has Precedence
• Creating Subqueries
• Specifying Conditions for Groups
• Specifying Search Conditions