is there any solution for this problem? i have 3 tables customers, orders, payments and i want total bill and payment for each customer in a table
query=>> SELECT c_id, c_name, c_contact, SUM(o_quantity*o_price) AS bill, SUM(p_total_payment) AS paid, SUM((o_quantity*o_price)-(p_total_payment)) FROM orders LEFT JOIN payments ON o_customer_id =…