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

5 votes172 views1 answer
Sysdate in oracle sql
SQL
13 votes179 views2 answers
Sql join 3 tables
SQL
11 votes181 views2 answers
Oracle saurce code
SQL
0 vote173 views3 answers
How to run sql query
SQL
0 vote177 views1 answer
Mysql type for large numbers with many decimal
SQL
8 votes203 views4 answers
Postgresql server restart
SQL
0 vote165 views1 answer
Inserting data into different tables at once in oracle sql
SQL
3 votes202 views1 answer
RENAME table pl sql
SQL
2 votes182 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote180 views1 answer
Big table in mysql
SQL