Check out example codes for "mysql order by date asc null last". It will help you in understanding the concepts better.

Code Example 1

SELECT * FROM user 

ORDER BY COALESCE(name, 'zz') DESC

Code Example 2

ORDER BY IF(ISNULL(my_field),1,0),my_field ASC

Learn ReactJs, React Native from akashmittal.com