Show first NON NULL and non-NaN parameter:

SELECT path, COALESCE(frontmatter->area, frontmatter->Area, '') AS Area
FROM obsidian_markdown_notes

SELECT CAST(COALESCE(hourly_wage * 40 * 52,
    salary,
    commission * num_sales) AS money) AS [Total Salary]
FROM wages
ORDER BY [Total Salary];