组合两个 where 语句

Question

我在结合下面的两个语句时遇到困难。我需要我的查询来查找语句 1 或语句 2。我不知道如何在两者之间添加OR语句。#Standard-SQL

报表 1

WHERE
(feedback IS NOT NULL OR text IS NOT NULL)
AND rating <= 2

报表2

WHERE
(rating = 3 OR rating = 4)
AND feedback IS NOT NULL

理想的结果是这样的...

WHERE
(feedback IS NOT NULL OR text IS NOT NULL)
AND rating <= 2
OR  
(rating = 3 OR rating = 4)
AND feedback IS NOT NULL

Answer 1

将两个 FULL 条件封装在括号中：

WHERE
(
(feedback IS NOT NULL OR text IS NOT NULL)
AND rating <= 2
)
OR 
( 
(rating = 3 OR rating = 4)
AND feedback IS NOT NULL
)