如何在sql中首先使用非空值按列排序

I need to write a sql statement to select all users ordered by lastname, firstname. This is the part I know how to do :) What I don't know how to do is to order by non-null values first. Right now I get this:I need to write a sql statement to select all u