Can anybody correct sql query?

Question

I need city and the number of vacancies, jobs in this city. City, Resumes, Vacancy - table.

Here is a query I wrote, but it does not work (the second left join does not work)

SELECT c.name city_name,
COUNT(v.id) vac_num, (r.id) res_num
FROM mnk_city c
LEFT JOIN mnk_vacancy
ON v.cityId = c.id
LEFT JOIN mnk_resume
ON c.id = r.cityId
GROUP BY c.name

Answer 1

It seems you are missing some table aliases - mnk_vacancy should be followed by v as far as I can see and mnk_resume should be followed by r.

SELECT c.name city_name,
COUNT(v.id) vac_num, (r.id) res_num
FROM mnk_city c
LEFT JOIN mnk_vacancy v
ON v.cityId = c.id
LEFT JOIN mnk_resume r
ON c.id = r.cityId
GROUP BY c.name

Answer 2

SELECT c.name city_name,   
COUNT(v.id) vac_num, (r.id) res_num 
FROM mnk_city c 
LEFT JOIN mnk_vacancy v
ON v.cityId = c.id 
LEFT JOIN mnk_resume r 
ON c.id = r.cityId 
GROUP BY c.name

You are missing the table aliases.