REGEXP_MATCH (Sum if matches the string)
I want to sum if two values matches in a particular column.
I tried with REGEXP_MATCH but it doesn't work with
REGEXP_MATCH(Status, '(Hired | Confirmed)');
How to use Or here to sum if value is "Hired" Or "Confirmed"?