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 vote293 views1 answer
Example database query
SQL
8 votes199 views2 answers
Replace string value in sql
SQL
0 vote216 views1 answer
Datagrip execute procedure
SQL
1 vote276 views1 answer
Connect to mysql database ubuntu
SQL
3 votes200 views1 answer
How to check schema privileges in oracle
SQL
0 vote184 views1 answer
How to execute stored output to csv files
SQL
0 vote216 views1 answer
Difference between db.query and db.execute
SQL
4 votes203 views1 answer
Oracle error line
SQL
19 votes195 views2 answers
Mysql tinyint max value
SQL
0 vote213 views1 answer
Drop view in mysql
SQL