使用类似命令和逻辑运算符的sqlite

Question

我试图根据具有逻辑或逻辑的类似命令来排除一些记录。他们单独工作，但共同工作。

 Select CustomerName
    ,Type
    ,sum(Quantity) as Total
     ,TimeDate 
    ,date(TimeDate) as JustDate
   ,DATE(date(TimeDate),'start of month') as BeginMonth
    , DATE(date(date(TimeDate),'start of month'),'+1 month') as BeginNextMonth
    ,DATE(date(TimeDate),'start of month','+1 month','-1 day') as EndOfMonth
     ,DATE(date(TimeDate),'start of month','-1 day')  as EndOfLastMonth
    from history
    where (Type not like '%LPG%') or (Type not like '%Hyster%')
    group by type,CustomerName

Answer 1

我犯的错误是使用或操作员应该使用，然后使用。