I have had a dig around but still having a problem with this. Below is the table structure:

JOBS

```
jobs_id | title

```

JOBS\_APLICATIONS

```
id | jobs_id | user_id | candidate_id | employer_id

```

I have this query..

```
SELECT ja.job_id, COUNT(*) AS count, j.title
FROM job_applications AS ja
LEFT JOIN jobs AS j
ON ja.jobs_id = j.jobs_id
GROUP BY ja.jobs_id

```

But it doesn't return any jobs that have no count e.g '0'. Please how do I change the query to show these?