title: How to count empty rows in postgresql?
body: <p>In my postgresql query given below and I want to <code>count(completed::float)</code></p>
  
  <pre><code>select round(Count(completed::float)) as completed,
         assignee 
  from NTE_23Apr19_HCMS_DOW_Defects_List_V1 
  group by assignee
  </code></pre>
  
  <p>This is my postgresql table</p>
  
  <p><img src="https://i.stack.imgur.com/FmrT9.png" alt="enter image description here"></p>
  
  <p>If I used without <strong>float</strong> in query it will works but I want to execute with float.Is It possible</p>
  
  <pre><code>select round(Count(completed)) as completed,
         assignee 
  from NTE_23Apr19_HCMS_DOW_Defects_List_V1 
  group by assignee
  </code></pre>