Mysql select inside sum

SELECT x.prod_name
     , SUM(x.total)
  FROM ( SELECT bp.prod_name
              , ( SELECT SUM( wh.quantity ) * bp.weight 
                    FROM bus_warehouse_entries wh
                   WHERE bp.prod_code = wh.org_product_code ) AS total
       FROM bus_products bp ) x
 GROUP BY x.prod_name

Source: stackoverflow.com

Similar codes

0 vote269 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote186 views1 answer
Restart sql server command line linux
SQL
0 vote197 views1 answer
Mysql exception output
SQL
0 vote219 views1 answer
Convert int to varchar sql
SQL
0 vote187 views1 answer
Mysql 5.7 in centos 7
SQL
15 votes194 views6 answers
Psql
SQL
20 votes208 views6 answers
Creating a table in sql
SQL
17 votes211 views3 answers
Postgresql version command
SQL
0 vote194 views1 answer
Sql server select value large text
SQL
3 votes243 views1 answer
How to uninstall microsoft sql server
SQL