Aggregate Functions - How to handle NULL

I use the sql scripts above to insert some data into another table, the system show the 'warning' message (inside the red rectangle) to me. I found the 'aggregation function' would eliminate the 'NULL' .

For example:

count(id), the value you will get is 4, but count(createuser), the value you will get is 3