title: getting error to run decode mysql command
body: <p>Not able to run/resolve this below query in mysql 8.0 </p>
  
  <p>Query: sum(decode(billflage,'N',0,instlamt) - nvl(recdamt,0)) WHERE DUEDATE &lt; SYSDATE</p>
  
  <p>with value: sum(decode('Y','N',0,2322 - nvl(2322,0))) Where 8/5/2016 12:00:00 &lt; 30/1/2020 12:00:00</p>
  
  <p>Please provide the output or how it will work in mysql 8.0</p>