title: How to replace NaN with 0 in SQL
body: <p>I'm trying to take the average and median of several values but they are coming out incorrectly because the values I have in the table that are supposed to be 0 are listed as NaN in the database.</p>
  
  <p>Is there a way I can replace all instances of NaN with 0 so that I can fix my average and median values?</p>