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 vote136 views1 answer
Ubuntu stop mysql from starting on boot
SQL
10 votes87 views1 answer
Oracle view dependencies
SQL
0 vote124 views1 answer
Deny select insert update delete sql
SQL
0 vote178 views1 answer
Mysql faster delete
SQL
0 vote136 views1 answer
Connect to nginx server mysql remotly
SQL
2 votes121 views1 answer
Sqlplus clear screen
SQL
0 vote129 views4 answers
Mysql desactivar trigger
SQL
0 vote142 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote140 views1 answer
How to create a new shema using query languaage
SQL
0 vote92 views1 answer
Check if due date is less than todays date sql
SQL