- Published on
Leetcode - 1082. Sales Analysis I
- Authors
- Name
- Indo Yoon
Table of Contents
문제
[Loading...
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
LeetCode
](https://leetcode.com/problems/sales-analysis-i/description/)
정답
SELECT seller_id FROM
(
SELECT seller_id, SUM(price) AS total
FROM Sales
GROUP BY seller_id
) AS T1
WHERE total IN
(
SELECT MAX(total) as max_total FROM (
SELECT seller_id, SUM(price) AS total
FROM Sales
GROUP BY seller_id
) AS T2
)