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 vote259 views1 answer
A network or instance-specific error sql server
SQL
2 votes261 views6 answers
In in sql
SQL
0 vote267 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote257 views1 answer
Mysql function variable
SQL
2 votes276 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote262 views1 answer
Tsql cmd exec script from file
SQL
0 vote254 views1 answer
Difference between cross apply and inner join
SQL
0 vote264 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote248 views1 answer
Postgres float to int
SQL
4 votes290 views3 answers
Sql drop database if exists
SQL