Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. 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
  2. inner join [order details] as od on od.orderid=o.orderid
  3. group by e.EmployeeID, e.firstname, e.lastname
  4. order by 4 desc
  5.  
  6.  
  7. select top 1 e.employeeID, e.firstname, e.lastname,
  8. (select sum(od.Quantity*od.UnitPrice*(1-od.Discount)) from [Order Details] as od
  9. where od.OrderID in (select o.orderid from orders as o where o.EmployeeID=e.EmployeeID and year(o.orderdate)=1997) )
  10. from Employees as e
  11. order by 4 desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement