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 vote112 views1 answer
Oracle create job if not exists
SQL
1 vote103 views1 answer
Can not connect to mysql server
SQL
0 vote113 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote121 views1 answer
How to save data in database in mysql node
SQL
1 vote133 views1 answer
Get parameter value in mysql trigger
SQL
8 votes124 views1 answer
Script to add datafile to tablespace
SQL
16 votes121 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote118 views2 answers
How to tun mysql on ubunto
SQL
4 votes111 views1 answer
Mysql insert from local csv
SQL
12 votes131 views4 answers
How to check mysql version ubuntu
SQL