Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select top 1 e.employeeID, e.firstname, e.lastname, sum(od.Quantity*od.UnitPrice*(1-od.Discount)) from Employees as einner join orders as o on o.employeeid = e.employeeid
- inner join [order details] as od on od.orderid=o.orderid
- group by e.EmployeeID, e.firstname, e.lastname
- order by 4 desc
- select top 1 e.employeeID, e.firstname, e.lastname,
- (select sum(od.Quantity*od.UnitPrice*(1-od.Discount)) from [Order Details] as od
- where od.OrderID in (select o.orderid from orders as o where o.EmployeeID=e.EmployeeID and year(o.orderdate)=1997) )
- from Employees as e
- order by 4 desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement