Faculty Roster with Default Status

Scenario

HR is exporting the faculty roster for the printed handbook. Most faculty have no fac_special_status set (the column is NULL), but the printed roster must show "Standard" for those rows instead of a blank. Use COALESCE to substitute the default.

Expected output

One row per faculty member in dbo.ods_faculty, sorted by faculty_id ascending. The special_status column shows special_status_desc when present, else the literal "Standard". Letter case is part of the answer.

Tables

Hints