1.选择客户中所有没有填写手机号的客户SELECT FROM customersWHERE phone *IS NULL 2.选择客户中所有填写手机号的客户SELECT FROM customersWHERE phone *IS NOT NULL 3.筛选出所有还没有被运输的订单SELECT FROM sql_store.ordersWHERE shipped_date *IS NULL