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 vote295 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote335 views1 answer
Oracle exchange subpartition
SQL
0 vote303 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
1 vote309 views1 answer
Sql server locks
SQL
0 vote307 views1 answer
Use between operator in mysql
SQL
2 votes297 views2 answers
Sqlite_busy: database is locked
SQL
0 vote344 views1 answer
How to install sql in anaconda
SQL
0 vote308 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote344 views1 answer
Mysql previous year
SQL
0 vote313 views2 answers
How to use aggregate functions in sql
SQL