title: Need help regarding multiple criteria in my where clause
body: <p>i have a simple query for my dataset:</p>
  
  <pre><code>SELECT * FROM efleet_copy
  WHERE EXTRACT(MONTH from service_date) = 02
  AND status = 'Approved' AND mta_id NOT LIKE '_________'
  ORDER BY mta_id;
  </code></pre>
  
  <p>What i need is to exclude transactions that satisfy this conditions:</p>
  
  <pre><code>provider = MTA CURB APP which is mta_id = 1
  provider = MTA CURB APP Streethail which is mta_id = 1
  provider = MTA CONCIERGE which is mta_id = 2
  </code></pre>
  
  <p>This is the sample data:</p>
  
  <p><a href="https://i.stack.imgur.com/BYsy3.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BYsy3.jpg" alt="enter image description here"></a></p>
  
  <p>I already tried these queries in my where clauses but it didn't work:</p>
  
  <pre><code>AND provider IN ('MTA CURB APP', 'MTA CURB APP Streethail') AND mta_id &lt;&gt; '1'
  AND provider IN ('MTA CONCIERGE') AND mta_id &lt;&gt; '2'
  </code></pre>
  
  <p>and</p>
  
  <pre><code>AND (provider = 'MTA CURB APP' AND mta_id &lt;&gt; '1') OR (provider = 'MTA CURB APP Streethail' AND mta_id &lt;&gt; '1') OR (provider = 'MTA CONCIERGE' AND mta_id &lt;&gt; '2')
  </code></pre>