title: MySQL sum() with condition in jOOQ
body: <p>MySQL will allow me to pass a condition as a parameter to SUM().</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT COUNT(*), SUM(value &gt; 100) FROM TABLE1;
  </code></pre>
  
  <p>As seen in <a href="https://stackoverflow.com/a/11377479/3419">this answer</a>. </p>
  
  <p>How do I do this in JOOQ?</p>