CTE query or SQL query

[harry]

[djj55]

1. what have you done?
2. where are you stuck?
3. will you always have just one "new"?

[harry]

i have done taking the lowest value in a group but i dont know how to do it