My table looks something like that

So i write the SQL query to get data on 13-10-22 as

| Source\_name | time | hash | data |
| --- | --- | --- | --- |
| America | 13-10-22 | vfdgh | Any |
| Africa | 12-10-22 | hgffgh | any |
| America | 13-10-22 | hhhnn | any |

```
SELECT source_name AS source, 
       COUNT(*) AS number_count
FROM mytable
WHERE time LIKE '%13-10-22%'
GROUP BY source_name

```

Output:

| source | number\_count |
| --- | --- |
| America | 2 |

But I'm expecting

| source | number\_count |
| --- | --- |
| America | 2 |
| Africa | 0 |

Please help.