Filter Using Multiple Conditions (AND/OR)

SQL

Technical Specification

Write a query to fetch users who are active AND from country = 'India', OR have role = 'admin'.

Input/Output Samples

Input:active + India, plus all admins

Output:Filtered list of users

Optimal Logic Path

SELECT *
FROM users
WHERE 
  (is_active = 1 AND country = 'India')
  OR role = 'admin';

Architectural Deep-Dive

Parentheses avoid confusion with default precedence of AND/OR.