5.13WHERE conditions
You'll recognize:
WHERE Status__c = 'Active'
Multiple conditions:
WHERE Status__c = 'Active'
AND BillingState = 'FL'
OR:
WHERE Industry = 'Technology'
OR Industry = 'Healthcare'
I recommend using parentheses when logic gets more complicated:
WHERE Status__c = 'Active'
AND (
BillingState = 'FL'
OR BillingState = 'GA'
)
Same reason you would in normal SQL: readability.