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

2 votes148 views2 answers
Postgresql search all tables for column name
SQL
0 vote202 views1 answer
Check user sql password from command line
SQL
18 votes137 views3 answers
Mysql number format
SQL
0 vote137 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote167 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote172 views1 answer
Jooq replace
SQL
0 vote148 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote97 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote148 views1 answer
Mariadb create index if not exists
SQL
1 vote141 views1 answer
Sql into vs insert into
SQL