sum(earnings) when title = 'Novice' as Novice_Earnings;
sum(earnings) when title = 'Journeyman' as Journeyman_Earnings;
sum(earnings) when title = 'Master' as Master_Earnings;

SELECT title, sum(earnings) as earnings
FROM business_ledger
GROUP BY title

SELECT
    title, certification, earnings
FROM business_ledger
WHERE certification in
    (SELECT certification
    FROM business_ledger
    )
GROUP BY title, certification
ORDER BY title, certification