Count not null in sql <p>i have a table A with column data:</p> <pre><code>mdr1222 ------- pprgd24 ------- invalid ------- invalid abc2345 </code></pre> <p>I want to get a count of the invalid and blank(---). I tried :</p> <pre><code>SELECT count(data) from A where data = 'invalid' and null </code></pre> <p>but it doesn't work. Can someone please help me figure out what i am doing wrong here. Thank you.</p>