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 vote144 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote119 views3 answers
Sql query checker
SQL
5 votes98 views2 answers
Oracle list columns schema
SQL
8 votes116 views1 answer
Mysql limit rows
SQL
1 vote116 views1 answer
Oracle sql create or replace view
SQL
10 votes99 views2 answers
Linux command line import mysql database
SQL
0 vote147 views1 answer
Run docker container with database as rds metabase
SQL
0 vote103 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
2 votes110 views3 answers
Postgres create view
SQL
0 vote105 views1 answer
Sql get month from date
SQL