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-6a2fea77eb5da082220803/] Expected...