# 1069. Product Sales Analysis II

https://leetcode.com/problems/product-sales-analysis-ii

## Description

Table: `Sales`

```

+-------------+-------+
| Column Name | Type  |
+-------------+-------+
| sale\_id     | int   |
| product\_id  | int   |
| year        | int   |
| quantity    | int   |
| price       | int   |
+-------------+-------+
sale\_id is the primary key of this table.
product\_id is a foreign key to Product table.
Note that the price is per unit.
```

Table: `Product`

```

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| product\_id   | int     |
| product\_name | varchar |
+--------------+---------+
product\_id is the primary key of this table.
```

Write an SQL query that reports the total quantity sold for every product id.

The query result format is in the following example:

```

Sales table:
+---------+------------+------+----------+-------+
| sale\_id | product\_id | year | quantity | price |
+---------+------------+------+----------+-------+ 
| 1       | 100        | 2008 | 10       | 5000  |
| 2       | 100        | 2009 | 12       | 5000  |
| 7       | 200        | 2011 | 15       | 9000  |
+---------+------------+------+----------+-------+

Product table:
+------------+--------------+
| product\_id | product\_name |
+------------+--------------+
| 100        | Nokia        |
| 200        | Apple        |
| 300        | Samsung      |
+------------+--------------+

Result table:
+--------------+----------------+
| product\_id   | total\_quantity |
+--------------+----------------+
| 100          | 22             |
| 200          | 15             |
+--------------+----------------+
```

## ac

```java
```
