title: SELECT max(x) is returning null; how can I make it return 0?
body: <p>How do you return 0 instead of null when running the following command:</p>
  
  <pre><code>SELECT MAX(X) AS MaxX
  FROM tbl
  WHERE XID = 1
  </code></pre>
  
  <p>(Assuming there is no row where XID=1)</p>