title: How to Convert MYSQL Query to Mongodb Aggregation
body: <p>how to convert mysql query to mongodb aggregation</p>
  <p>my database in mysql</p>
  <p><a href="https://i.stack.imgur.com/jACuo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jACuo.png" alt="enter image description here" /></a></p>
  <p>i need to convert mysql to mongodb query</p>
  <pre><code>SELECT * FROM `auctions` WHERE ( (status!='SCHEDULED' AND status='FAILED') OR (status!='RUNNING' AND status='FAILED') ) GROUP BY auctioncode
  </code></pre>
  <p>in this query auctioncode and status are wise record needed auctioncode is multiple records. i need status='FAILED' that auctioncode status not in <strong>SCHEDULED</strong> or <code>UNPAID</code></p>