Sales Analysis I LeetCode Solution

/ Leetcode Solution / Easy, LeetCode Solution, MySql, SQL

Last updated on October 9th, 2024 at 10:44 pm

This Leetcode problem Sales Analysis I LeetCode Solution is done in SQL.

List of all LeetCode Solution

Level of Question

Easy

Sales Analysis I LeetCode Solution

Problem Statement

Column Name	Type
product_id	int
product_name	varchar
unit_price	int

Table: Product

product_id is the primary key (column with unique values) of this table. Each row of this table indicates the name and the price of each product.

Column Name	Type
seller_id	int
product_id	int
buyer_id	int
sale_date	date
quantity	int
price	int

Table: Sales

This table can have duplicate rows. product_id is a foreign key (reference column) to the Product table. Each row of this table contains some information about one sale.

Write an SQL query that reports the best seller by total sales price, If there is a tie, report them all.

The result format is in the following example.

product_id	product_name	unit_price
1	S8	1000
2	G4	800
3	iPhone	1400

Product table:

seller_id	product_id	buyer_id	sale_date	quantity	price
1	1	1	2019-01-21	2	2000
1	2	2	2019-02-17	1	800
2	2	3	2019-06-02	1	800
3	3	4	2019-05-13	2	2800

Sales table:

Output:

seller_id

Explanation:
Both sellers with id 1 and 3 sold products with the most total price of 2800.

1. Sales Analysis I LeetCode Solution MySQL

select 
  seller_id 
from 
  Sales 
group by 
  seller_id 
having 
  sum(price) >= (
    select 
      sum(price) as total_price 
    from 
      Sales 
    group by 
      seller_id 
    order by 
      total_price desc 
    limit 
      1
  );

Sales Analysis I LeetCode Solution

Table of Contents

Problem Statement

1. Sales Analysis I LeetCode Solution MySQL

Related Posts