Mysql multi-table query case
# case: select city employees who work in Toronto
SELECT last_name,job_id,e.department_id,department_nameFROM employees AS eJournal published AS d journal AS lWHERE e.`department _ id` = d.`department _ id`and d.`location _ id` = l.`location _ id`AND l.citybaby toronto'
# case; query the number of countries with more than 2 departments under each country
SELECT country_id, COUNT (*) FROM locations AS AS dWHERE l.`location _ id` = d.`location _ id`GROUP BY country_idHAVING COUNT (*) > 2
