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 vote178 views1 answer
How to print out column name differently in mysql
SQL
1 vote178 views1 answer
Restart identity postgresql
SQL
0 vote220 views1 answer
Postgresql on conflict pair
SQL
1 vote184 views3 answers
Mysql connection string
SQL
0 vote183 views1 answer
Python sql last insertend
SQL
9 votes176 views4 answers
How to remove duplicate in sql
SQL
0 vote191 views1 answer
Get a list of tables and the primary key
SQL
0 vote192 views1 answer
Join in update query in mysql
SQL
0 vote173 views1 answer
Resulting Query
SQL
7 votes191 views3 answers
Sql set
SQL