数据库格式如下:
SELECT
t1.YEAR,
t1.quantity / t2.quantity increase_rate
FROM
year_sales t1
INNER JOIN year_sales t2 ON t1.YEAR - 1 = t2.YEAR
结果如下
数据库格式如下:
SELECT
t1.YEAR,
t1.quantity / t2.quantity increase_rate
FROM
year_sales t1
INNER JOIN year_sales t2 ON t1.YEAR - 1 = t2.YEAR
结果如下