Count of a column with different rows

Question

I want to join two tables (below) which i get. But then I want to do a count to see how many times each job_category is shown when contactId > 0

Any Help would be appreciated!

Tablel :

| JobPositionId | JobPositionName | JobDescriptionId | JobCategoryId | ContactId
---------------------------------------------------------------------------------
       1        |  Audio Cables   |      1           |      1        |     1
       2        |Audio Connections|      2           |      1        |     1
       3        |Audio Connections|      2           |      1        |     0
       4        |   Sound Board   |      3           |      1        |     0
       5        |   Tent Pen      |      4           |      3        |     0

Table2 :

JobCategoryId | JobCategoryName
 --------------------------------
      1       |  Audio Setup
      2       |  Stage Setup
      3       |  Tent Setup

Answer 1

Something like

select jc.JobCategoryName, count(*) 
from JobCats jc inner join JobPostings jp on jc.JobCategoryId = jp.JobCategoryId
where jp.ContactId > 0
group by jp.JobCategoryId

Answer 2

Does this give you what you want:

SELECT Table2.JobCategoryId, Table2.JobCategoryName, COUNT(Table2.JobCategoryId)
FROM Table1
INNER JOIN Table2 ON Table1.JobCategoryId = Table2.JobCategoryId
WHERE Table1.ContactId > 0
GROUP BY Table2.JobCategoryId, Table2.JobCategoryName