sql.md

RL - Answer

SELECT NAME, SALARY 
FROM EMPLOYEES 
ORDER BY SALARY DESC;

SELECT 
    d.NAME AS DEPARTMENT_NAME, 
    AVG(e.SALARY) AS AVG_SALARY
FROM 
    DEPARTMENTS d
JOIN 
    EMPLOYEES e ON d.ID = e.DEPARTMENT_ID
GROUP BY 
    d.NAME;

SELECT 
    e.NAME, 
    r.TITLE
FROM 
    EMPLOYEES e
JOIN 
    DEPARTMENTS d ON e.DEPARTMENT_ID = d.ID
JOIN 
    ROLES r ON r.TITLE = 'Senior'
WHERE 
    d.NAME = 'Engineering' 
    AND e.SALARY >= r.MIN_SALARY;