bazy 4

select last_name, department.name, sum(total)
from employee inner join job on employee.job_id = job.job_id inner join customer on employee.employee_id = customer.salesperson_id inner join sales_order on customer.customer_id = sales_order.customer_id inner join department on employee.department_id = department.department_id
where function='SALESPERSON' and total > 1280 and order_date >= '91/10/19'
group by last_name, department.name;