Write a query that will return sales details of all customers and products. The query should return

Fantastic news! We've Found the answer you've been seeking!

Question:

Write a query that will return sales details of all customers and products. The query should return all customers, even customers without invoices and also all products, even those products that were not sold. Print "N/A" for a null customer or product name, and 0 for a null quantity.For each row return customer name, product name, and the' quantity of the product sold. Order the result ascending by customer id, product id and invoice item id.

Tables:

Customer

idcustomer_namecity_idcustomer_addresscontact_personemailphone

Product

idskuproduct_nameproduct_descriptioncurrent_pricequantity_in_stock

Invoice

idinvoice_numbercustomer_iduser_account_idtotal_pricetime_issuedtime_duetime_paidtime_canceledtime_refunded

Invoice_Item

idinvoice_idproduct_idquantitypriceline_total_price

I have tried this, but it didn't work:

SELECT
COALESCE(c.name, 'N/A') AS customer_name,
COALESCE(p.name, 'N/A') AS product_name,
COALESCE(ii.quantity, 0) AS quantity
FROM
customer c
CROSS JOIN
product p
LEFT JOIN
invoice i ON c.id = i.customer_id
LEFT JOIN
invoice_item ii ON i.id = ii.invoice_id AND p.id = ii.product_id
ORDER BY
c.id, p.id, ii.id;