Data Query API sub query failed general database error

Scenario:

We have DEPT field on the task level. Multiple tasks could have same DEPT. If one of the tasks with same DEPT is changed by user today, we want to retrieve all the tasks for that same DEPT. 

Trying the below query but it is throwing general database error

q:"Select Name, LastUpdatedOn, CreatedOn, CreatedBy.Name, LastUpdatedBy.Name, C_DEPTID FROM Task WHERE C_DEPTID in (SELECT C_DEPTID FROM Task WHERE LastUpdatedOn = '08/24/2021')", paging: {"limit":10}