Why isn't it working

Question

Why does the query with GROUP BY not work and three values are returned? Can anyone help me?
https://sololearn.com/compiler-playground/c1qiew47g99e/?ref=app

Answer 1

You have an extra space in your data. I changed your query to include the field you are grouping on. That gave me this result:

('Baleen whale', 22.5)
('Baleen whale', 16.0)
('Dental whale', 2.1)

Answer 2

In aggregate values surely it will print a single value but here you have given in a group by subordination text where in 2 types of subordination values you had given while inserting into the table that is the reason it should print 2 values but I am unsure why it is printing 3 values.

Answer 3

Thank you very much👍