count, PostgreSQL - rextester

Language: Layout:

drop table if exists main_data cascade;

CREATE TABLE main_data (
    id serial PRIMARY KEY,
    name VARCHAR(255) default NULL,
    lastname VARCHAR(255) default NULL,
    username VARCHAR(255) default NULL,
    job VARCHAR(255) default NULL,
    age integer  default NULL,
    licenseid integer  default NULL,
    account integer  default NULL
);

INSERT INTO main_data VALUES(1,'Jhon', 'Brown', 'jbrown', 'some job', 35, 11112333, 3333455);
INSERT INTO main_data VALUES(2,'Bob', NULL, 'bob', 'another job', 64, 1000500, 5555252);
INSERT INTO main_data VALUES(3,'Mike', 'McDonald', 'mike', NULL, 8, NULL, NULL);

select *, 
       (select count(*) 
        from jsonb_each_text(to_jsonb(t) - 'id' - 'name') as x(k,v)
        where v = 'Yes')
from (
  select id, name,
          case when lastname notnull then 'Yes' else 'No' end as "has_lastname",
          case when username notnull then 'Yes' else 'No' end as "has_username",
          case when job notnull then 'Yes' else 'No' end as "has_job",
          case when age < 16 then 'Yes' else 'No' end as "is_child",
          case when licenseid notnull then 'Yes' else 'No' end as "has_licenseid",
          case when account notnull then 'Yes' else 'No' end as "has_account"
  from main_data
) t  
order by id


absolute service time: 0,52 sec