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

6 votes159 views1 answer
Oracle rank
SQL
0 vote166 views1 answer
Java spring boot connect to sql server
SQL
0 vote164 views1 answer
How to insert same table data using mysql query
SQL
0 vote143 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
8 votes195 views6 answers
Insert command in sql
SQL
0 vote182 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote151 views1 answer
Sql group by error
SQL
0 vote149 views1 answer
Sql count null values in all columns
SQL
0 vote151 views1 answer
How to list function in psql
SQL
0 vote157 views1 answer
Narural join
SQL