=================
SELECT
SUM(sub_total) AS sales,
CASE WHEN (sub_total<100) THEN '0-99'
WHEN (sub_total>=100 AND sub_total<200) THEN '100-199'
WHEN (sub_total>=200 AND sub_total<300) THEN '200-299'
WHEN (sub_total>=300 AND sub_total<400) THEN '300-399'
WHEN (sub_total>=400 AND sub_total<500) THEN '400-499'
ELSE '500+'
END
AS product_sales_range
FROM order_item
GROUP BY sub_total
============= ===========
sales product_sales_range
----- -------------------
10398.96 200-299
600 100-199
300 0-99
7699.78 300-399
6799.32 100-199
600 0-99
26599.24 500+
=========================== ===============
sales product_sales_range sales_increase_by_10% sales_increase_by_20%
----- ------------------- ------------------ ------------------
10398.96 200-299
600 100-199
300 0-99
7699.78 300-399
6799.32 100-199
600 0-99
26599.24 500+
============
В настоящее время у нас есть данные о продажах. Необходимо узнать прогноз продаж, как если бы продажи вырастут на 10%, 20%, 30% и т. Д. Пример: сегодня продажи для product_sales_range (0-99) равны 300. Если продажи увеличивается на 10%, значение sales_increase_by_10% должно быть 330
Я что-то упустил, или вам просто нужно использовать:
SELECT SUM(sub_total) AS sales,
CASE WHEN (sub_total<100) THEN '0-99'
WHEN (sub_total>=100 AND sub_total<200) THEN '100-199'
WHEN (sub_total>=200 AND sub_total<300) THEN '200-299'
WHEN (sub_total>=300 AND sub_total<400) THEN '300-399'
WHEN (sub_total>=400 AND sub_total<500) THEN '400-499'
ELSE '500+'
END AS product_sales_range,
SUM(sub_total) * 1.1 AS sales_increase_by_10Percent,
SUM(sub_total) * 1.2 AS sales_increase_by_20Percent
FROM order_item
GROUP BY sub_total