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 vote252 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote208 views1 answer
Expose db in virtualbox
SQL
0 vote264 views1 answer
Oracle select partition
SQL
0 vote248 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote283 views1 answer
Oracle session statistics
SQL
6 votes275 views2 answers
How to get yesterday date in mysql
SQL
0 vote252 views1 answer
Database get 10 user aleatory
SQL
0 vote256 views1 answer
Replace content value from old to new sql
SQL
1 vote253 views1 answer
Postgres first_value in gropby
SQL
1 vote255 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL