Shulou(Shulou.com)06/01 Report--

# 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.