I have 2 tables:

```
t_job
 - id
 - name

t_person:
 - id
 - name
 - job_id (fk t_job->id)

t_other_jobs
 - person_id (fk t_person->id)
 - job_id (fk t_job->id)

```

So basically I have people who have main job and 0 or more secondary jobs.
What I want to do is create query that gives me something like this:

```
PERSON NAME | ALL JOBS COUNT

```

and

```
JOB NAME | HOW MANY PEOPLE HAVE THEM

```

So if a person have main job (its a foreign key so he must have it) and 2 other jobs. Result would be:

```
Jorge | 3

```