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

0 vote193 views1 answer
Sql getdate minus 1 day without time
SQL
9 votes198 views4 answers
Mysql set id auto increment
SQL
0 vote178 views1 answer
Sql right characters
SQL
0 vote231 views2 answers
How to get max from each department in sql
SQL
24 votes179 views5 answers
Sql reset auto increment
SQL
0 vote206 views1 answer
Get last three characters in mysql column
SQL
0 vote187 views1 answer
MySql get primary keys of table
SQL
0 vote186 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote192 views1 answer
Connexion mysql
SQL
0 vote252 views1 answer
Insert query return id mysql
SQL