如何从这段丑陋的代码中重写"where，and，or“语句

-- 原始代码
SELECT * FROM users WHERE age > 18 AND (city = 'New York' OR city = 'Los Angeles');

-- 重写后的代码
SELECT *
FROM users
WHERE (age > 18 AND city = 'New York') OR (age > 18 AND city = 'Los Angeles');

-- 原始代码
SELECT * FROM users WHERE city = 'New York' OR city = 'Los Angeles';

-- 重写后的代码
SELECT * FROM users WHERE city IN ('New York', 'Los Angeles');

-- 原始代码
SELECT * FROM users WHERE status = 'active' AND (type = 'admin' OR type = 'superadmin');

-- 重写后的代码
SELECT *,
       CASE
           WHEN status = 'active' AND type IN ('admin', 'superadmin') THEN 'Yes'
           ELSE 'No'
       END AS isAdminOrSuperadmin
FROM users;

-- 原始代码
SELECT * FROM users WHERE age > 18 AND city = 'New York' OR age > 25 AND city = 'Los Angeles';

-- 重写后的代码
SELECT * FROM users WHERE age > 18 AND city = 'New York'
UNION
SELECT * FROM users WHERE age > 25 AND city = 'Los Angeles';