mehrdad - 2020-04-05

hi
how can i create query that count total number of specific state of each bug?

i have field that call "env" it means multiple environmens like: dev, test, opr, ....

i want to write query that show how many time "env" status change to test?
like this, below bug state of "env" 5 times change to the "test":

bug_id | count send to test
10 | 5

thanks