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 vote252 views1 answer
Mysql print variable
SQL
5 votes218 views1 answer
Oracle asynchronous procedure
SQL
2 votes233 views1 answer
Sql get the name of user pc
SQL
0 vote238 views1 answer
How to select a row in sql
SQL
0 vote248 views1 answer
Sql show table name in result
SQL
0 vote198 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
11 votes222 views2 answers
Having keyword sql
SQL
0 vote239 views1 answer
Psql datestyle
SQL
0 vote230 views1 answer
Horizontal join sqlite
SQL
0 vote194 views1 answer
Get last run query sql server
SQL