SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (col1, col2, col3);
✓
INSERT INTO table_name VALUES 
  (1, null, null), (null, 10, 'Bob'), (100, 'Jane', 3), (null, '2022-08-18', X'abcd')
✓
SELECT * FROM table_name;

col1
col2
col3

1
null
null

null
10
Bob

100
Jane
3

null
2022-08-18
abcd

SELECT COUNT(*) result FROM table_name WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL;

result

3

SELECT COUNT(*) result FROM table_name WHERE col1 + col2 + col3 IS NULL;

result

3

SELECT COUNT(*) result FROM table_name WHERE col1 || col2 || col3 IS NULL;

result

3

SELECT COUNT(*) result FROM table_name WHERE MAX(col1, col2, col3) IS NULL;

result

3