Which approach counts records that meet multiple conditions?

Which approach counts records that meet multiple conditions?

• A. Use a Logical OR to Combine Conditions
• B. Count Records That Meet Any Single Condition
• C. Use a Logical AND to Combine Conditions
• D. Apply a Filter on Only the First Condition

Answer: (C)

Combining conditions with a logical AND ensures you count records only when every specified criterion is true. In practice, you set multiple requirements and require all of them to be met for a record to be included in the count. For example, counting customers who live in London AND have spent over 100 pounds means only those who satisfy both conditions are counted. If you used OR, you’d include records that meet at least one condition, which isn’t what “multiple conditions” implies. Filtering on only the first condition would ignore the other criteria entirely, giving a count that doesn’t reflect all the requested conditions.

Combining conditions with a logical AND ensures you count records only when every specified criterion is true. In practice, you set multiple requirements and require all of them to be met for a record to be included in the count. For example, counting customers who live in London AND have spent over 100 pounds means only those who satisfy both conditions are counted. If you used OR, you’d include records that meet at least one condition, which isn’t what “multiple conditions” implies. Filtering on only the first condition would ignore the other criteria entirely, giving a count that doesn’t reflect all the requested conditions.