The WHERE clause can contain multiple conditions that are grouped by using logical operators (AND, OR) and parentheses.
SELECT AccountId, Status, Priority FROM Case WHERE Status ='Closed' AND Priority = 'High'
SELECT AccountId, Status, Priority FROM Case WHERE Priority = 'Medium' OR Priority = 'High'