SQL: improve tests with respect to NULL values in columns

At the moment, the integration testing we have uses sample data that doesn't have any empty/null column values. We should improve this by adjusting the sample data to include the aforementioned values and add tests to cover related scenarios, as well.