SQL Output with Nulls at the bottom of the output

1.sql

SELECT schools.id AS schoolid,schools.name AS school,districts.id AS districtid, districts.name AS district
FROM sms_schools AS schools
LEFT JOIN sms_districts AS districts ON schools.districtid = districts.id
WHERE 1 = 1
ORDER BY (CASE WHEN districts.id IS NULL then 1 ELSE 0 END),districts.name, schools.name;

2.sql

SELECT 
  schools.id AS schoolid,
  schools.name AS school,
  districts.id AS districtid,
  (CASE WHEN districts.name IS NULL THEN 'Other' ELSE districts.name END) AS district
FROM sms_schools AS schools
LEFT JOIN sms_districts AS districts ON schools.districtid = districts.id
WHERE 1 = 1
ORDER BY (CASE WHEN districts.id IS NULL then 1 ELSE 0 END),districts.name, schools.name