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 vote357 views1 answer
TSQL convert csv to table
SQL
6 votes384 views4 answers
Mysql update set
SQL
6 votes403 views2 answers
How to get last element sql
SQL
0 vote392 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote349 views2 answers
Sql trigger difference between for and after
SQL
2 votes338 views1 answer
Apex date today add days
SQL
0 vote365 views1 answer
Sql server create constraint
SQL
5 votes346 views1 answer
Oracle ORA-00054 origin
SQL
0 vote395 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote384 views1 answer
Mysql where don't have string
SQL