6.1按条件筛选(与,或,非) #数据筛选AND SELECT * FROM data1 WHERE city='shanghai' AND age>30; #数据筛选IN SELECT * FROM data1 WHERE city IN ('shanghai','bei