view column names not updating

I am trying to create a view with columns that are the result of a sum statement.  For instance, when I add the code:

SELECT STATE, SUM(child_count) as Total_Children

from STATE_STATS

group by STATE;

The Total_Children column does not auto_populate  the column name or data type when I choose to "update_columns".  

the column names come back as column_n and the datatype comes back as "unknown".

How do I make this work correctly so that I do not have to manually rekey every column?