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 vote198 views1 answer
How to check xampp mysql password
SQL
0 vote218 views1 answer
Sql database connectivity
SQL
0 vote202 views2 answers
Show slave status mysql
SQL
6 votes205 views3 answers
Mysql first day of year
SQL
0 vote206 views1 answer
SQL Server modify_timestamp trigger
SQL
3 votes184 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
2 votes226 views1 answer
Column names in oracle sql
SQL
1 vote264 views1 answer
Postgres set sequence value to max id
SQL
-1 vote230 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote218 views1 answer
Postgresql create table with boolean column
SQL