How can the query results include null if it's a required field on the front end?

I executed a query that simply asked for all data points on a single table.

I am trying to figure out why the query would report back as having all "Null" values in 3 of 10 columns. The information is required for the end user to enter before the system allows them save a record.