On the order by line, I get an error saying that it's missing a right parenthesis, but I have no idea why.
SELECT LAST_NAME AS "Last Name", DEPARTMENT_ID AS "Department Id", SALARY AS
Salary
FROM EMPLOYEES JOIN DEPARTMENTS
USING(DEPARTMENT_ID)
WHERE SALARY IN (SELECT MIN(SALARY)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID, SALARY
ORDER BY DEPARTMENT_ID);
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…