Expression to calculate and filter the data

[ymeht]

 Hi All,

I have two table job and  company. i want to calcualte   count of companies  which are closed  and has job in job table.

 job table:

jobid  ,jobeneterdate,company ID

company:

ID,Name, status: closed , Live  etc.

 now  for one company there can be multiple job in job table.

TIA