SQL中where语句实现两个字段取两组不同的值

#查询18岁的女性和80岁的男性

SELECT * FROM user
WHERE
age = 18 AND sex = "female"
OR
age = 80 AND sex = "male";


#查询语文和数学都是100分的学生
SELECT user FROM result
WHERE
class = "语文" AND score = "100"
OR
class = "数学" AND score = "100"
group by user
HAVING count(user) = 2;

类似需求：

https://tieba.baidu.com/p/5634716213?red_tag=0494898888#