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 vote114 views1 answer
Optimize sql query
SQL
6 votes117 views1 answer
What is where clause in sql
SQL
0 vote114 views3 answers
CONTACT FORM SQL
SQL
4 votes108 views1 answer
Oracle table statistics last analyzed
SQL
12 votes121 views1 answer
How to change the value of a table in sql
SQL
3 votes127 views1 answer
Sql datetime as date
SQL
2 votes130 views1 answer
Sql skip the first row
SQL
2 votes120 views1 answer
Datetrunc
SQL
1 vote109 views1 answer
Select dba users oracle
SQL
0 vote105 views1 answer
Get who is hired in month in sql
SQL