SQL Puzzle: SQL Advance Query – Find the Order basis on thier Status and Step

Check the below input data and require output data to find order which step is 0 with status D and for the same order other status are P. Input Data: [crayon-69f45bd4a5380771173035/] Expected...