Reporting querry - Select incidents by user's department

Hi,

I'm trying to build a querry which will extract all incidents for a project which were raised by members of the same department.

I was able to create some of the pieces of the querry (see below) but I am not able to put them together into a single querry so that I get the report I'm after. Anyone able to provide some help with this?

select value R from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId}
select value R from SpiraTestEntities.R_Incidents as R where R.OWNER_ID = 'Tom'
select R.USER_ID from SpiraTestEntities.R_Users as R where R.DEPARTMENT= 'ICT'

I am able to select the incidents by user and the users which are part of the ICT department, however I don't know how to combine it all together.

Thanks for any help.