MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.7.34


CREATE TABLE test
(
  n_brand VARCHAR (25) NOT NULL,
  population VARCHAR (25) NOT NULL,
  actions_u_user INTEGER NOT NULL
);
INSERT INTO test VALUES
('pepsico',	'pepsicoeur',	1),
('pepsico',	'pepsicoeur',	1),
('pepsico',	'pepsicoeur',	1),
('pepsico',	'pepsicousa',	1),
('pepsico',	'pepsicousa',	2),
('pepsico',	'pepsicousa',	2),
('pepsico',	'pepsicomex',	0),
('pepsico',	'pepsicomex',	2),
('ferrari',	'ferrarieur',	1),
('ferrari',	'ferrarieur',	1),
('ferrari',	'ferrariusa',	0),
('ferrari',	'ferrarimex',	1),
('ferrari',	'ferrarimex',	1);
SHOW VARIABLES LIKE '%sql_mode%';


Variable_name
Value


sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


SELECT n_brand , population, actions_u_user
FROM test
WHERE n_brand = 'pepsico'
AND actions_u_user > 0
GROUP BY population
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_512655057.test.actions_u_user' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT n_brand , population, actions_u_user
FROM test
WHERE n_brand = 'pepsico'
AND actions_u_user > 0
GROUP BY n_brand, population, actions_u_user
ORDER BY n_brand, population;


n_brand
population
actions_u_user


pepsico
pepsicoeur
1

pepsico
pepsicomex
2

pepsico
pepsicousa
1

pepsico
pepsicousa
2


SELECT DISTINCT n_brand, population, actions_u_user
FROM test
WHERE n_brand = 'pepsico'
  AND actions_u_user > 0
ORDER BY n_brand, population;


n_brand
population
actions_u_user


pepsico
pepsicoeur
1

pepsico
pepsicomex
2

pepsico
pepsicousa
1

pepsico
pepsicousa
2


SELECT n_brand , population, actions_u_user, SUM(actions_u_user) AS sum_p
FROM test
WHERE n_brand = 'pepsico'
AND actions_u_user > 0
GROUP BY n_brand, population, actions_u_user;


n_brand
population
actions_u_user
sum_p


pepsico
pepsicoeur
1
3

pepsico
pepsicomex
2
2

pepsico
pepsicousa
1
1

pepsico
pepsicousa
2
4


SET sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
SHOW VARIABLES LIKE '%sql_mode%';


Variable_name
Value


sql_mode
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


SELECT n_brand , population, actions_u_user
FROM test
WHERE n_brand = 'pepsico'
AND actions_u_user > 0
GROUP BY population;


n_brand
population
actions_u_user


pepsico
pepsicoeur
1

pepsico
pepsicomex
2

pepsico
pepsicousa
1


SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
SHOW VARIABLES LIKE '%sql_mode%';


Variable_name
Value


sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


SELECT 
  SUM(actions_u_user) AS "The sum of all" 
FROM test;


The sum of all


14


SELECT 
  n_brand AS "The Brand",      

  -- for presentation purposes. With multi-word aliases, 
  -- you have to use double quotes! 

  population AS "Population", 
  SUM(actions_u_user) AS "The column name"  

  -- or AS col_name - no quotes necessary if there are no
  -- spaces in the column alias
    
FROM test
GROUP BY n_brand, population
ORDER BY n_brand, population;


The Brand
Population
The column name


ferrari
ferrarieur
2

ferrari
ferrarimex
2

ferrari
ferrariusa
0

pepsico
pepsicoeur
3

pepsico
pepsicomex
2

pepsico
pepsicousa
5


SELECT 
  n_brand AS "The Brand",      

  -- for presentation purposes. With multi-word aliases, 
  -- you have to use double quotes! 

  population AS "Population", 
  SUM(actions_u_user) AS "The column name"  

  -- or AS col_name - no quotes necessary if there are no
  -- spaces in the column alias
    
FROM test

WHERE n_brand = 'pepsico'   -- added these two lines 
  AND actions_u_user > 0

GROUP BY n_brand, population
ORDER BY n_brand, population;


The Brand
Population
The column name


pepsico
pepsicoeur
3

pepsico
pepsicomex
2

pepsico
pepsicousa
5
n_brand	population	actions_u_user
pepsico	pepsicoeur	1
pepsico	pepsicomex	2
pepsico	pepsicousa	1
pepsico	pepsicousa	2
The Brand	Population	The column name
ferrari	ferrarieur	2
ferrari	ferrarimex	2
ferrari	ferrariusa	0
pepsico	pepsicoeur	3
pepsico	pepsicomex	2
pepsico	pepsicousa	5