title: combining comparisons operators
body: <p>Please advise how to change the following code to extract also records with [execution_status] like 'failure' and at the same time [has_messages] like '0'. I'm trying different ways and all the time results include has_messages both '0' and '1' :(. Thanks a lot!!</p>
  
  <pre><code>SELECT * 
  FROM (SELECT [id]
              ,[type]
              ,[created]
              ,dateadd(s, created/1000, '19700101')as date_created
              ,[state]
              ,[execution_status]
              ,[has_messages]
        FROM [databasename].[tablename] 
        WHERE type like 'AccessRequest' 
          AND not state like 'Initialize') as jaro 
  WHERE date_created between '2016-12-01' and '2016-12-31'
  ORDER by date_created
  </code></pre>