Groupby sort sql hive

SELECT 
    place, 
    cnt, 
    sum_ 
FROM (
    SELECT 
        place, 
        count(*) as cnt, 
        sum(weight) as sum_ 
    FROM a 
    GROUP BY place
) a 
ORDER BY place;

Source: stackoverflow.com

Similar codes

1 vote174 views1 answer
Mysql get last insert id
SQL
0 vote206 views1 answer
Create a plsql object
SQL
0 vote174 views1 answer
Postgresql heritage
SQL
0 vote165 views1 answer
Sql date d'aujourd'hui
SQL
1 vote168 views1 answer
Postgres get timestamp
SQL
2 votes224 views1 answer
Mariadb json select
SQL
4 votes214 views1 answer
Sql delete multiple conditions
SQL
16 votes235 views6 answers
Mysql find duplicates in same table
SQL
0 vote174 views1 answer
Sql not exists
SQL
-2 votes184 views2 answers
Union all in sql
SQL