SELECT distinct COUNT(USER_CODE) count_user,ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION
from EMPLOYER_JOB_POST ejp inner join EMPLOYER_APPLY_JOB eaj on
eaj.COMPANY_CODE=eaj.COMPANY_CODE where eaj.COMPANY_CODE='CC0000001'
group by ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION