Acknowledgement issue

Hello Experts,

I am not an expert in outlook.

My problem statement is - 

I want to find out how many mails I have in my inbox that do not have a specific mail ID in "CC" or "TO" and also have not been acknowledged (replied) yet.

I tried below SQL to filter those mails, which are not acknowledged, but not sure how to add condition for a specific mail ID. Please help.

Regards