mysql - 总销售成本的 15%

Question

难以弄清楚如何计算销售表总数的 15%

这是我目前所得到的(总和)。发现在同一查询中显示总销售额和 15% 的销售额有困难。

SELECT SUM(prices) AS total sales FROM sales;

Answer 1

您可以将总和乘以 0.15:

SELECT SUM(prices) AS total_sales,
       SUM(prices) * 0.15 AS fifteen_percent
FROM   sales;