统计每个员工处理的订单总数, 结果包含员工IDemployee_id，姓名first_name 和 last_name，处理的订单总数(别名 orders_count)

数据导入请看：数据导入

# 场景1: 只统计有订单的 员工的情况.   交集: 内连接.
select
    e.employee_id, e.last_name, e.first_name,   # 分组字段: 员工的id, 姓, 名
    count(order_id) as orders_count
from
    employees e
join orders o on e.employee_id = o.employee_id
group by
    # e.employee_id, e.last_name, e.first_name;
    e.employee_id;

# 场景2: 查看所有员工的订单总数, 哪怕为0.  差集: 左外连接.
select
    e.employee_id, e.last_name, e.first_name,   # 分组字段: 员工的id, 姓, 名
    count(order_id) as orders_count
from
    employees e
left join orders o on e.employee_id = o.employee_id
group by
    # e.employee_id, e.last_name, e.first_name;
    e.employee_id;
# 验真: 4,Peacock,Margaret,155
select * from orders where employee_id = 4;        # 共 155 条;
select * from orders where employee_id = 10;        # 共 1 条;