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 votes309 views1 answer
Postgresql group by month and year
SQL
0 vote187 views1 answer
Mysql add to number
SQL
1 vote181 views1 answer
Partition by sql server
SQL
0 vote183 views1 answer
Fast sql column count
SQL
0 vote253 views1 answer
Varchar2 length in oracle
SQL
0 vote193 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote206 views1 answer
Set classpath for mysql-connector.jar
SQL
2 votes181 views1 answer
Sql server case sensitive search
SQL
0 vote197 views4 answers
Mysql replace regex
SQL
0 vote238 views1 answer
Google sheets data validation custom formula filter
SQL