SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename(name TEXT, value NUMERIC)
INSERT INTO tablename(name, value) VALUES
  ('name1', 41), 
  ('name1', 41), 
  ('name2', 39.9);
SELECT name, typeof(value) FROM tablename


name
typeof(value)


name1
integer

name1
integer

name2
real


SELECT name, SUM(value)
FROM tablename
GROUP BY name


name
SUM(value)


name1
82

name2
39.9