/SQL/ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function

ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function

SELECT m.cname, m.wmname, t.mx
FROM (
    SELECT cname, MAX(avg) AS mx
    FROM makerar
    GROUP BY cname
    ) t JOIN makerar m ON m.cname = t.cname AND t.mx = m.avg
;

 cname  | wmname |          mx           
--------+--------+------------------------
 canada | zoro   |     2.0000000000000000
 spain  | usopp  |     5.0000000000000000

Source: stackoverflow.com

Similar codes

0 vote135 views1 answer
How to put is null in where in clause
SQL
28 votes172 views6 answers
Foreign key
SQL
2 votes132 views2 answers
Mamp connect mysql terminal
SQL
1 vote156 views1 answer
How to get alternate records from a table in sql
SQL
0 vote325 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote128 views1 answer
Get max salary from each department sql
SQL
0 vote121 views1 answer
Insert data from stored procedure into table
SQL
0 vote142 views1 answer
How to get nth number in sql
SQL
0 vote124 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote133 views1 answer
Oracle sql drop table
SQL