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 vote100 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote105 views1 answer
Mysql bash execute sql file
SQL
2 votes151 views1 answer
Oracle Column Names of a table
SQL
0 vote112 views1 answer
Select year from dual oracle
SQL
0 vote116 views1 answer
How to run mysql on terminal mac
SQL
0 vote101 views1 answer
Sql case when exists in another table
SQL
1 vote135 views1 answer
Epoch time converter in snowflake
SQL
0 vote102 views1 answer
Drush run sql select
SQL
0 vote98 views1 answer
Create boolean column in MySQL with false as default value?
SQL
9 votes115 views2 answers
Convert data type in sql
SQL