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

3 votes307 views1 answer
Increment integer in table sql
SQL
2 votes269 views1 answer
Plsql left() function
SQL
1 vote285 views2 answers
Drop table if exists test
SQL
3 votes297 views3 answers
Docker create postgresql database
SQL
0 vote261 views1 answer
Create dabase postgresql
SQL
1 vote320 views1 answer
How to put value in variable mysql
SQL
-1 vote293 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote315 views1 answer
Table user postgres
SQL
0 vote296 views1 answer
Hibernate show sql xml property
SQL
0 vote271 views1 answer
Power query datetime to date
SQL