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

4 votes118 views1 answer
Refresh postgres config
SQL
0 vote120 views2 answers
Postgresql variable in query
SQL
0 vote105 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote126 views1 answer
Mysql dump specific tables
SQL
0 vote107 views1 answer
Procedure excute monthly oracle
SQL
1 vote104 views1 answer
Base nosql
SQL
0 vote110 views1 answer
SAP Return
SQL
2 votes115 views1 answer
Oracle convert run_duration to number
SQL
-1 vote118 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote118 views1 answer
Psql generate id in existing database
SQL