MySQL计算百分比

2021-11-20 00:00:00 percentage mysql

我有一个包含 4 个项目的 MySQL 数据库:id(数字)、group_name、employees 和 surveys.

I have a MySQL database with 4 items: id (numerical), group_name, employees, and surveys.

在我的 SELECT 中，我需要根据调查"中的数字计算参加调查的员工"的百分比.

In my SELECT I need to calculate the percentage of 'employees' who, by the number in 'surveys', have taken the survey.

这是我现在的声明:

SELECT
  group_name,
  employees,
  surveys,
  COUNT( surveys ) AS test1, 
  ((COUNT( * ) / ( SELECT COUNT( * ) FROM a_test)) * 100 ) AS percentage
FROM
  a_test
GROUP BY
  employees

这是现在的表格:

INSERT INTO a_test (id, group_name, employees, surveys) VALUES
(1, 'Awesome Group A', '100', '0'),
(2, 'Awesome Group B', '200', '190'),
(3, 'Awesome Group C', '300', '290');

我想通过调查中的数字来计算参加调查的员工的百分比.即如上数据所示，Awesome Group A 为 0%，Awesome Group B 为 95%.

I would love to calculate the percentage of employees who by the number in surveys have taken the survey. i.e. as shown in the data above, the Awesome Group A would be 0% and Awesome Group B would be 95%.

推荐答案

试试这个

   SELECT group_name, employees, surveys, COUNT( surveys ) AS test1, 
        concat(round(( surveys/employees * 100 ),2),'%') AS percentage
    FROM a_test
    GROUP BY employees

此处演示

相关文章