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

10 votes238 views2 answers
Show tables in schema oracle
SQL
11 votes256 views5 answers
Sql server reset identity
SQL
0 vote227 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote227 views1 answer
Oracle procedure chain step
SQL
6 votes225 views1 answer
Sqlite foreign key
SQL
0 vote237 views1 answer
Mysql loop through databases and execute query
SQL
0 vote239 views1 answer
Sql decode
SQL
0 vote247 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote270 views1 answer
Joomla execute raw sql
SQL
0 vote239 views1 answer
Mysql equivalent decode oracle
SQL