product-sales-analysis-iii

java

python

python3

mysql

mssql

oraclesql

csharp

javascript

typescript

bash

swift

kotlin

dart

golang

ruby

scala

rust

racket

erlang

elixir

pythondata

postgresql

cangjie

Database

Table: <code>Sales</code>

<pre>
+-------------+-------+
| Column Name | Type |
+-------------+-------+
| sale_id | int |
| product_id | int |
| year | int |
| quantity | int |
| price | int |
+-------------+-------+
(sale_id, year) is the primary key (combination of columns with unique values) of this table.
product_id is a foreign key (reference column) to <code>Product</code> table.
Each row records a sale of a product in a given year.
A product may have multiple sales entries in the same year.
Note that the per-unit price.

</pre>

Write a solution to find all sales that occurred in the first year each product was sold.

<ul data-end="1234" data-start="992">
	<li data-end="1078" data-start="992">
	For each <code data-end="1015" data-start="1003">product_id</code>, identify the earliest <code data-end="1045" data-start="1039">year</code> it appears in the <code data-end="1071" data-start="1064">Sales</code> table.
	</li>
	<li data-end="1140" data-start="1079">
	Return all sales entries for that product in that year.
	</li>
</ul>

Return a table with the following columns: product_id, first_year, quantity, and price. 
Return the result in any order.

&nbsp;
Example 1:

<pre>
Input: 
Sales table:
+---------+------------+------+----------+-------+
| sale_id | product_id | year | quantity | price |
+---------+------------+------+----------+-------+ 
| 1 | 100 | 2008 | 10 | 5000 |
| 2 | 100 | 2009 | 12 | 5000 |
| 7 | 200 | 2011 | 15 | 9000 |
+---------+------------+------+----------+-------+

Output: 
+------------+------------+----------+-------+
| product_id | first_year | quantity | price |
+------------+------------+----------+-------+ 
| 100 | 2008 | 10 | 5000 |
| 200 | 2011 | 15 | 9000 |
+------------+------------+----------+-------+
</pre>

sales_analysis

Product Sales Analysis III

Product Sales Analysis II

product-sales-analysis-ii

产品销售分析 II

Product Sales Analysis IV

product-sales-analysis-iv

产品销售分析 IV

Product Sales Analysis V

product-sales-analysis-v

产品销售分析Ⅴ

销售表&nbsp;<code>Sales</code>：

<pre>
+-------------+-------+
| Column Name | Type |
+-------------+-------+
| sale_id | int |
| product_id | int |
| year | int |
| quantity | int |
| price | int |
+-------------+-------+
(sale_id, year) 是这张表的主键（具有唯一值的列的组合）。
product_id 是产品表的外键（reference 列）。
这张表的每一行都表示：编号 product_id 的产品在某一年的销售额。
一个产品可能在同一年内有多个销售条目。
请注意，价格是按每单位计的。
</pre>

编写解决方案，选出每个售出过的产品&nbsp;第一年 销售的 产品 id、年份、数量&nbsp;和 价格。

<ul>
	<li>对每个 <code>product_id</code>，找到其在Sales表中首次出现的最早年份。</li>
	<li>返回该产品在该年度的 所有 销售条目。</li>
</ul>

返回一张有这些列的表：product_id，first_year，quantity&nbsp;和&nbsp;price。

结果表中的条目可以按 任意顺序 排列。

&nbsp;

示例 1：

<pre>
输入：
Sales 表：
+---------+------------+------+----------+-------+
| sale_id | product_id | year | quantity | price |
+---------+------------+------+----------+-------+ 
| 1 | 100 | 2008 | 10 | 5000 |
| 2 | 100 | 2009 | 12 | 5000 |
| 7 | 200 | 2011 | 15 | 9000 |
+---------+------------+------+----------+-------+
输出：
+------------+------------+----------+-------+
| product_id | first_year | quantity | price |
+------------+------------+----------+-------+ 
| 100 | 2008 | 10 | 5000 |
| 200 | 2011 | 15 | 9000 |
+------------+------------+----------+-------+</pre>