I can't seem to get a basic SQL query to work in SQLite. It's just a single 8 column table in db-browser for sqlite. Some of the data-types aren't correct here, but it shouldn't impact end results

I'm getting no results returned, it should be 116 results.

Data represented in SQLite

[![enter image description here](https://i.stack.imgur.com/XJBQ0.png)](https://i.stack.imgur.com/XJBQ0.png)

Basic SQL statement

[![enter image description here](https://i.stack.imgur.com/QCvaF.png)](https://i.stack.imgur.com/QCvaF.png)

```
select
    `CountyName`,
    gender,
    sum(population)
from secondTable
where Year = 2014
group by `CountyName`, gender
order by `CountyName`, gender

```