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

6 votes360 views6 answers
Count mysql
SQL
0 vote371 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote363 views1 answer
Mysql timediff
SQL
0 vote345 views1 answer
Acual month sql
SQL
4 votes311 views1 answer
And or sql order of operations
SQL
10 votes385 views2 answers
What is database
SQL
2 votes377 views1 answer
How to delete columns in sql
SQL
0 vote416 views1 answer
Insert using condition postgres
SQL
7 votes332 views2 answers
Create mysql user
SQL
0 vote374 views1 answer
Reona
SQL