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 vote319 views1 answer
Oracle insert single quote in string
SQL
4 votes340 views4 answers
Remove duplicate old value in mysql
SQL
0 vote290 views1 answer
Execut sql python
SQL
0 vote291 views1 answer
Vowels in sql
SQL
1 vote323 views1 answer
How to see logical reads in sql server
SQL
0 vote290 views1 answer
How to display value of variable in mysql
SQL
0 vote312 views1 answer
Query builder doctrien return sql
SQL
0 vote294 views1 answer
OFFSET consulta mysql
SQL
0 vote288 views1 answer
Drop domain postgresql
SQL
-1 vote279 views2 answers
On update cascade
SQL