Values in list

[Anonymous]

Hello, 

I need some help with the following. I have a dataset consisting of different matches and their historical stages. I want to calculate how many of those matches have stage "3.1 | Kandidaat voorgesteld aan klant" and from those how many also have stage "4.0 | Kandidaat mag op gesprek bij klant". In SQL it would look like this: 

select *
from matches_hist mh
where mh.stage = '4.0 | Kandidaat mag op gesprek bij klant' and mh.matchID in
(select distinct mh.matchID
from matches_hist mh
where mh.stage = '3.1 | Kandidaat voorgesteld aan klant'

)

I have troubles with the second part in the SQL code  

mh.matchID in (select distinct matchID
from matches_hist mh
where stage = '3.1 | Kandidaat voorgesteld aan klant'

)

I have tried using values(), but I am not able to add the condition stage = '3.1 | Kandidaat voorgesteld aan klant'

Could anyone help me with this problem?

Thanks in advance!

Regards, Gino

[Anonymous · Accepted solution]

I was able to find a solution myself. For the people wanting to know. You can use the functions calculatetable(values(), <filter conditions>).