Get the Count with appropriate column

Hi
I am Working on Job Search Portal Project. I have 2 Tables. 1. City Table [CityID(PK), CityName] 2. Job Post Location Table[ID(PK), JobPostID(FK), CityID(FK)] JobPostID is ID which various Jobs are posted. My Table Data: 1. City Table CityID  CityName ---------------------- 1         Nasik 2         Mumbai 3         Pune 4         Chennai
2. Job Post Location Table ID  JobPostID  CityID --------------------------- 1    1              2 2    1              1 3    2        & ...