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

5 votes129 views1 answer
Sql first day of current year
SQL
0 vote149 views1 answer
Mysql group by derived column
SQL
1 vote187 views1 answer
Size of all tables in a schema oracle
SQL
2 votes162 views1 answer
Revokeprivileges mysql
SQL
0 vote158 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote160 views1 answer
Set open file limit mac catalina mysql
SQL
2 votes135 views1 answer
SELECT INTO
SQL
0 vote146 views2 answers
How to drop mili second in sql
SQL
2 votes143 views1 answer
No data found oracle
SQL
1 vote136 views1 answer
Too many connections mysql
SQL