assuming the name of the table is "jobs" and the name of the column is "departments"
you could use the following SQL for Brokerage:
SELECT * FROM jobs WHERE departments LIKE 'Brokerage%'
and this for Carrier:
SELECT * FROM jobs WHERE departments LIKE 'Carrier%'