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 vote131 views1 answer
How much table store postgres
SQL
1 vote143 views5 answers
Sql 2nd highest salary
SQL
21 votes122 views1 answer
Cheatsheet for sql
SQL
0 vote128 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote129 views1 answer
Pl sql round
SQL
0 vote135 views1 answer
Renommer schema sql
SQL
1 vote127 views1 answer
Oracle stop job
SQL
-3 votes119 views1 answer
Remove spaces sql 2008
SQL
1 vote131 views2 answers
T-sql random number for each row
SQL
11 votes130 views1 answer
Ddl materialized view
SQL