If row this boolan than

I have a table that looks like this:

For each phase in the column Phase there should be a new column calledPhase_2, which lists how often the value in the column road_type changes between (Urban;Rural;Motoway).

I want a result like this: