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 vote187 views1 answer
Floor function in sql oracle
SQL
0 vote219 views1 answer
Createdb with postgresql on ubuntu
SQL
4 votes339 views1 answer
What are the data types
SQL
-1 vote270 views1 answer
Sql show custom constraints
SQL
57 votes2.3K views5 answers
How to create a new user in postgresql
SQL
9 votes190 views3 answers
Show table columns mysql command line
SQL
10 votes268 views6 answers
Mysql set root password
SQL
1 vote251 views1 answer
Oracle drop chain step
SQL
0 vote337 views1 answer
Mysql failed to login as root@localhost
SQL
13 votes203 views5 answers
Oracle list tables
SQL