Answer the following questions and also justify your answers with appropriate examples
Question: 1. When to use AND function to set multiple conditions that must be met?
Question: 2. How to use AND function to set multiple conditions that must be met?
Question: 3. When to use OR function to set multiple conditions that must be met?
Question: 4. How to use OR function to set multiple conditions that must be met?
Question: 5. When to use IN function to set multiple conditions that must be met?
Question: 6. How to use IN function to set multiple conditions that must be met?
How to use AND function to set multiple conditions that must be met and use OR function to set multiple conditions.