SQL Select Inside Select

SELECT d.`id` AS `company_id`, d.`name` AS `company_name`, d.`company_logo`, i.`name` AS `industry`, (
    SELECT MAX(v.`update_date`)
    FROM `ccn_employer_vacancy` v
    WHERE v.`publish` = 1 AND v.`swt_users_id` = t.`swt_users_id` AND v.`is_closed` = 0
)  AS `last_update`, (
    SELECT COUNT(*) FROM `ccn_employer_vacancy` vc
    WHERE vc.`is_closed` = 0 AND vc.`employer_data_id` = t.`employer_data_id`
) AS `total_vacancy`
FROM ccn_employer_vacancy t
LEFT OUTER JOIN ccn_employer_data d ON (d.`swt_users_id` = t.`swt_users_id`)
LEFT OUTER JOIN ccn_careerpedia_industry i ON (i.`id` = d.`ccn_employer_industry_id`)
WHERE t.`is_closed` = 0
GROUP BY t.`swt_users_id`