updated query for integration tests to match reported values