LiQuid,

интересно, откуда это? забугорный ресурс и такой примитив

LiQuid,

h. Write a SQL query to find the "manager_ID" and the "salary of the lowest-paid
employee(s)" under that manager.

select Manager_id, min(Salary) as lowest_paid from Employees
group by Manager_id

i. Write a SQL query to get the "department_ID" and the "total salary payable in each
department".

select department_ID, sum (Salary) as total from Employees
group by department_ID

j. Write a SQL query to get "the average salary" for each job position excluding
"Salesman"

select Job_name, avg(Salary) as average_salary from Employees
where Job_name not like '%Salesman%'
group by Job_name