看图一个修改一个查询，有偿可以

Question

按照图片上的条件写就行，速来，没了。后面我说的啥不用看，要满60个字才能发帖子

Answer 1

UPDATE  employees SET   salary = 3000 WHERE salary < 3000 AND   hire_date >= '2022-1-1';

SELECT  t.department_name,e.*
FROM    (   SELECT      dept.department_id, dept.department_name, MIN(emp.salary) min_salary
            FROM        employees emp
                        INNER JOIN departments dept ON dept.department_id = emp.department_id
            GROUP BY    dept.department_id, dept.department_name) t
        INNER JOIN employees e ON t.department_id = e.department_id AND e.salary = t.salary;