\"color:#005CC5;--shiki-dark:#79B8FF\">name</span></span>\n<span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">ORDER BY</span><span style=\"color:#005CC5;--shiki-dark:#79B8FF\"> e</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">.</span><span style=\"color:#005CC5;--shiki-dark:#79B8FF\">employee_id</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">;</span></span></code></pre>"},{"language":"PostgreSQL","code":"SELECT e.employee_id, e.name, COUNT(r.employee_id) AS reports_count,\n ROUND(AVG(r.age))::int AS average_age\nFROM Employees e\nJOIN Employees r ON r.reports_to = e.employee_id\nGROUP BY e.employee_id, e.name\n

Related Tags