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 vote209 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
6 votes220 views2 answers
What is non relational database
SQL
1 vote184 views1 answer
Mysql show current queries
SQL
0 vote212 views1 answer
How to print some string in mysql
SQL
31 votes167 views1 answer
Postgresql add column with constraint
SQL
2 votes179 views1 answer
Query any digits record
SQL
3 votes165 views4 answers
Stop MySQL
SQL
0 vote195 views1 answer
Codigo crear tablas sql server
SQL
1 vote165 views2 answers
Sql select only first occurrence
SQL
0 vote191 views1 answer
Create query in where clasue
SQL