I have a table `Jobs` that has five columns:

```
Skill1, Skill2, Skill3, Skill4, Skill5

```

Each column is linked with a same table `Job_Skill_Cat` as a foreign key.

I want to count number of jobs related to each skill.

The output should be like 

```
Java (5)jobs
C++ (23)jobs
Python (34)jobs

```

I have tried my best but I was only able to fetch number of jobs related to `skill1`.

```
SELECT 
    COUNT(JOB_ID), skill_name  
FROM
    jobs 
INNER JOIN
    job_skill_cat ON jobs.emplj_skill1 = job_skill_cat.skill_id 
GROUP BY
    skill_name

```

Any kind of help will be highly appreciated.