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

1 vote249 views1 answer
Python clean sql string
SQL
1 vote167 views1 answer
Best configuration for display table in sqlplus
SQL
8 votes176 views1 answer
Alter tablespace add datafile autoextend
SQL
13 votes152 views2 answers
Display users in mysql
SQL
0 vote173 views1 answer
Date 3 months from today sql
SQL
1 vote168 views2 answers
Logical operators in sql
SQL
0 vote156 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote149 views2 answers
Mysql output csv
SQL
0 vote146 views1 answer
How to reset AI in sql
SQL
0 vote183 views1 answer
Pl sql search in all packages
SQL