8) Most money made by an empoyee
SELECT TOP 1 emp.EmpID, SUM(Price * Qty) AS TotalMoney
FROM Sale
    INNER JOIN emp
        ON emp.EmpID = sale.EmpID
    INNER JOIN sale_bow
        ON sale_bow.SaleID = sale.SaleID
    INNER JOIN bow
        ON bow.BowID = sale_bow.BowID
GROUP BY emp.EmpID
ORDER BY TotalMoney DESC

9) Most bows sold by an employee
SELECT TOP 1 emp.EmpID, SUM(sale_bow.Qty) AS BowsSold
FROM Sale
    INNER JOIN emp
        ON emp.EmpID = sale.EmpID
    INNER JOIN sale_bow
        ON sale_bow.SaleID = sale.SaleID
    INNER JOIN bow
        ON bow.BowID = sale_bow.BowID
GROUP BY emp.EmpID
ORDER BY BowsSold DESC