Modify this query so the deptcode – In the realm of search optimization, modifying queries to enhance relevance and precision is a crucial skill. By incorporating department codes into search…