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 vote141 views1 answer
Mysql server not running
SQL
0 vote140 views2 answers
How to create a table from another table in sql derby
SQL
1 vote153 views1 answer
Increase date by one day in sql oracle
SQL
3 votes140 views2 answers
Check data in table mysql
SQL
0 vote131 views1 answer
Convert rows to columns in sql server
SQL
16 votes141 views2 answers
Oracle ddl
SQL
0 vote132 views1 answer
Postgres float to int
SQL
3 votes141 views2 answers
See mysql users ubuntu
SQL
0 vote147 views2 answers
Create-toys-table-with-toy_name-column
SQL
7 votes136 views5 answers
Oracle alter table
SQL