Sciuridae => YSITD: @koru1130 SELECT id as order_id , (SELECT SUM(order_item.quantity * products.price) FROM order_item INNER JOIN products ON order_item.product_id = products.id WHERE order_item.order_id = orders.id ) as total FROM orders; #60c6026b237860daba8fa84e

Sciuridae says to YSITD

@koru1130 SELECT id as order_id , (SELECT SUM(order_item.quantity * products.price) FROM order_item INNER JOIN products ON order_item.product_id = products.id WHERE order_item.order_id = orders.id ) as total FROM orders;

at Sun, Jun 13, 2021 9:04 PM