Добавление нового столбца провоцирует вывод ненужных данных

SELECT FirstName||' '||LastName "Employee", EXTRACT(YEAR FROM Orders.OrderDate) "Year",
 MAX(Order_Details.UnitPrice*Order_Details.Quantity-((Order_Details.UnitPrice*Order_Details.Quantity)*Order_Details.Discount)) "Price"
FROM Employees
FULL JOIN Orders ON
Employees.EmployeeID = Orders.EmployeeID 
FULL JOIN Order_Details
ON Orders.OrderID = Order_Details.OrderID
WHERE TO_CHAR(EXTRACT(YEAR FROM Orders.OrderDate)) = 1997
GROUP BY FirstName||' '||LastName, EXTRACT(YEAR FROM Orders.OrderDate)
ORDER BY "Price" DESC

SELECT FirstName||' '||LastName "Employee", Orders.OrderID, 
MAX(Order_Details.UnitPrice*Order_Details.Quantity-((Order_Details.UnitPrice*Order_Details.Quantity)*Order_Details.Discount)) KEEP(DENSE_RANK LAST ORDER BY Employees.EmployeeID) OVER (PARTITION BY Orders.OrderID)  "Best Order Price"
FROM Employees
FULL JOIN Orders ON
Employees.EmployeeID = Orders.EmployeeID 
FULL JOIN Order_Details ON 
Orders.OrderID = Order_Details.OrderID
WHERE TO_CHAR(EXTRACT(YEAR FROM Orders.OrderDate)) = 1997
GROUP BY FirstName||' '||LastName, EXTRACT(YEAR FROM Orders.OrderDate)
ORDER BY Orders.OrderID, "Best Order Price" DESC

SELECT last_name, department_id, salary,
   MIN(salary) KEEP (DENSE_RANK FIRST ORDER BY commission_pct)
      OVER (PARTITION BY department_id) "Worst",
   MAX(salary) KEEP (DENSE_RANK LAST ORDER BY commission_pct)
      OVER (PARTITION BY department_id) "Best"
    FROM employees
    ORDER BY department_id, salary;

SELECT FirstName||' '||LastName "Employee", Orders.OrderID,
MAX(Order_Details.UnitPrice*Order_Details.Quantity-((Order_Details.UnitPrice*Order_Details.Quantity)*Order_Details.Discount)) KEEP(DENSE_RANK FIRST ORDER BY Employees.EmployeeID)  "Best Order Price"
FROM Employees
FULL JOIN Orders ON
Employees.EmployeeID = Orders.EmployeeID 
FULL JOIN Order_Details
ON Orders.OrderID = Order_Details.OrderID
WHERE TO_CHAR(EXTRACT(YEAR FROM Orders.OrderDate)) = 1997
GROUP BY FirstName||' '||LastName, EXTRACT(YEAR FROM Orders.OrderDate)
ORDER BY "Best Order Price" DESC