sql count withoud NULL code example

Example: how to count null values

HOW TO COUNT NULL VALUES
List<String> list = new ArrayList(Arrays.asList
                              ("Java",null,"Python",null, "Ruby"));
CollectionUtils.filter(list, PredicateUtils
                           .nullPredicate()); ==> keeps only nulls
System.out.println(list.size());