with tabl as (select 1 as a_id,  0 as a
union select  2, 0 
union select  3, 1 
union select  4, 0 
union select  5, 0 
union select  6, 1 
union select  7, 0 
union select  8, 1 
union select  9, 1 
union select  10, 0 
)
select case a when 1 then 1 else 0 end as PPP, * from tabl order by a_id

with tabl as (select 1 as a_id,  0 as a
union select  2, 0 
union select  3, 1 
union select  4, 0 
union select  5, 0 
union select  6, 1 
union select  7, 0 
union select  8, 1 
union select  9, 1 
union select  10, 0 
)
select case when a=1 and lag(a,1,0) over(order by a_id)=0 then 1 else 0 end as PPP, * from tabl order by a_id