select控制行，where控制列

not(A and B)= not A or not B

in(a, b, c) = a or b or c

A or B and C = (A or B) and C

select distinct col_A, col_B from table的返回结果里，第一列里没有重复值，因为distinct可以去重