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 vote180 views1 answer
Join in update query in mysql
SQL
11 votes204 views2 answers
Insert date sql
SQL
3 votes180 views1 answer
Oracle function
SQL
0 vote172 views1 answer
Sql examples from your work
SQL
6 votes183 views3 answers
Mysql first day of year
SQL
2 votes191 views1 answer
Mysql clear screen
SQL
0 vote205 views1 answer
Hibernate show sql xml property
SQL
7 votes182 views4 answers
How to reset the identity column in sql server
SQL
5 votes194 views1 answer
Oracle list functions
SQL
59 votes313 views6 answers
Alter table sql
SQL