Hi.
I have one table:

test(id, value, id_student)

My primary key is id and id_student.
I want to put in it a column computed by:

select count(id_student) from test where id = :id and value is not null

How can I do this?

The :id must be the id of each record.