/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 vote300 views1 answer
No query unable to fetch row sqlite
SQL
2 votes282 views3 answers
How to pass password mysql command line
SQL
1 vote302 views1 answer
Sql string function update replace
SQL
15 votes275 views2 answers
How to know the username of postgresql
SQL
0 vote319 views1 answer
Postgresql print sessions using the database
SQL
0 vote337 views2 answers
Suse Linux restart MySQL
SQL
0 vote239 views1 answer
Mysql convert column to uppercase
SQL
6 votes314 views3 answers
Rename column ORACLE
SQL
1 vote303 views1 answer
What is a Database?
SQL
32 votes304 views6 answers
How to change column name in sql
SQL