SELECT e.first_name || ' ' || e.last_name AS 员工, m.first_name || ' ' || m.last_name AS 经理 FROM employees e INNER JOIN employees m ON m.employee_id = e.manager_id ORDER BY 经理;
SELECT e.first_name || ' ' || e.last_name AS 员工, m.first_name || ' ' || m.last_name AS 经理 FROM employees e LEFT JOIN employees m ON m.employee_id = e.manager_id ORDER BY 经理;
SELECT * FROM 国家;
SELECT * FROM 部门;
SELECT * FROM 受抚养人;
SELECT * FROM 员工;
SELECT * FROM 工作;
SELECT * FROM 地点;
SELECT * FROM 地区;
