nulls.sql

CREATE TABLE tmp4(tmp_id integer);
insert into tmp4 (tmp_id) values (1), (2), (null);

select count(order_id <> 1) from (values (null),(1),(2)) t(order_id);
 count
-------
     2

select count(*) from tmp4 where tmp_id <> 1;
count
-------
     1
(1 row)