--set salary = 0 where salary is null We don't fill null values with mean or middle values because this employees is joined recently and there salary is not updated on data yet.
No external database is required - this example uses SQLite in-memory database.
As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...