Livingston, I took the logic What you have mentioned, I took the count of those days which are matching in both assgn_dtm and complet_dtm and then deducting those from sum of all days

This has to be implemented in another query, so I have used a function to return the diff of days

Thank you all for your time and support