LeetCode--1082. 销售分析 I

drop table if EXISTS product;
drop table if EXISTS sales;
create table product
(
product_id int,
product_name varchar(20),
unit_price DECIMAL
);
create table sales(
seller_id int,
product_id   int,
buyer_id    int,
sale_date  date,
quantity   int, 
price  int
);

insert into product values(1, "S8", 1000);
insert into product values(2, "G4", 800);
insert into product values(3, "iphone", 1400);
insert into sales values(1, 1, 1, '2019-01-21', 2, 2000);
insert into sales values(1, 2, 2, '2019-02-17', 1, 800);
insert into sales values(2, 2, 3, '2019-06-02', 1, 800);
insert into sales values(3, 3, 4, '2019-05-13', 2, 2800);

select seller_id
from (select seller_id, dense_rank() over(order by sum(price) desc) rk from sales
group by seller_id) t  
where rk=1