Update Negative Numbers to Zero

How would you update a list of numbers in SQL?

Use the number_list table. Update every negative number_value to 0; leave zero, positive, and NULL values unchanged.

Output

1. Return one row for each updated record, with columns id and number_value.
2. Ignore rows where number_value is NULL.
3. Order the results by id ascending.