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 vote220 views1 answer
Implode in sql query
SQL
6 votes181 views1 answer
Update left join mysql
SQL
0 vote189 views1 answer
ACCEPT nome PROMPT on oracle
SQL
10 votes187 views2 answers
Mysql drop database if exists
SQL
0 vote174 views1 answer
Mariadb search columns
SQL
1 vote135 views1 answer
Postgresql last element of array
SQL
8 votes177 views1 answer
Sql limit results returned
SQL
11 votes218 views1 answer
Oracle view source
SQL
0 vote183 views1 answer
Mysql date only no time
SQL
2 votes187 views4 answers
Sql query interview questions
SQL