CREATE TABLE Sellers( 
  id INT PRIMARY KEY NOT NULL,
    Name VARCHAR(20) NULL,  
    Age INT NULL,
  Salary INT NULL,                          
)
 
INSERT dbo.Sellers (id, Name, Age, Salary)  
VALUES (1, 'Sara', 61, 3000),
     (2, 'Billy', 20, 4500),    
     (3, 'Dan', 23, 2400),
     (4, 'Joe', 35, 7800)   
 
CREATE TABLE Orders( 
  NUMBER INT NULL,
    Order_date DATE NULL,  
    Salesperson_id INT NOT NULL,
  Amount INT NULL,                          
)
 
INSERT dbo.Orders (NUMBER, Order_date, Salesperson_id, Amount)  
VALUES (10, '2006-08-02', 2, 540),
     (20, '2019-01-03', 2, 1800),   
     (30, '2015-07-14', 1, 640),
     (40, '2018-01-29', 2, 2400),   
     (50, '2018-02-03', 3, 600),
     (60, '2009-03-02', 4, 720),    
     (70, '2008-05-06', 2, 150),
     (80, '2019-01-02', 2, 101),    
     (90, '2018-06-07', 3, 40)

select top(1) with ties s.Name
     , sum(isnull(o.Amount, 0)) as Quantity
  from Sellers as s
 inner join Orders as o
    on s.id = o.Salesperson_id
 where o.Order_date is not null and o.Order_date > '20091231'
 group by s.id, s.Name
having count(o.Salesperson_id) > 1
 order by sum(isnull(o.Amount, 0)) desc
        , row_number() over(partition by s.id order by (select null))