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

11 votes210 views2 answers
Oracle saurce code
SQL
8 votes187 views1 answer
Oracle add months to sysdate
SQL
1 vote178 views1 answer
Avg mysql
SQL
1 vote204 views2 answers
Insert sqlite
SQL
0 vote204 views1 answer
Bitmap join index
SQL
1 vote242 views1 answer
Oracle repeat_interval 5 minutes
SQL
9 votes253 views6 answers
Replace sql
SQL
1 vote202 views1 answer
Rows to comma separated values in mssql
SQL
22 votes208 views3 answers
Remove all records from table mysql
SQL
10 votes210 views1 answer
How to import database in mysql by cmd
SQL