然后如何筛选单个员工或五个以上员工在同一个供应商没人十次以上的消费

要筛选出单个员工或多于五个员工在同一个供应商下单次消费超过十次的情况，你可以使用SQL的JOIN、GROUP BY、HAVING和COUNT函数。假设我们有两个表，一个是`EmployeeTransactions`，另一个是`Suppliers`，我们可以这样做：

1. 首先，联接两个表，基于供应商名(`SupplierName`)：

SELECT ET.EmployeeID, E.EmployeeName, S.SupplierName, COUNT(*) AS TransactionCount
FROM EmployeeTransactions ET
JOIN Suppliers S ON ET.SupplierName = S.SupplierName
GROUP BY ET.EmployeeID, E.EmployeeName, S.SupplierName;

2. 对每个员工和供应商组合计数。

3. 使用HAVING子句筛选出单个员工或消费次数超过五次的群体：

-- 单个员工消费超过10次
SELECT * FROM (
    SELECT ET.EmployeeID, E.EmployeeName, S.SupplierName, COUNT(*) AS TransactionCount
    FROM EmployeeTransactions ET
    JOIN Suppliers S ON ET.SupplierName = S.SupplierName
    GROUP BY ET.EmployeeID, E.EmployeeName, S.SupplierName
) AS SubQuery
WHERE (ET.EmployeeID = '单个员工ID') OR (TransactionCount > 5);

-- 消费超过五次的员工组
SELECT * FROM (
    SELECT ET.EmployeeID, E.EmployeeName, S.SupplierName, COUNT(*) AS TransactionCount
    FROM EmployeeTransactions ET
    JOIN Suppliers S ON ET.SupplierName = S.SupplierName
    GROUP BY ET.EmployeeID, E.EmployeeName, S.SupplierName
) AS SubQuery
HAVING COUNT(*) > 5;

记得替换 `'单个员工ID'` 为你要查询的具体员工ID。