zlargon · November 7, 2019 11:10
diff --git a/invoice_items.csv b/invoice_items.csv
diff --git a/invoices.csv b/invoices.csv
diff --git a/query.sql b/query.sql
 select
    Total,
    TotalSaleValue
 from invoices
 natural join (
    select
        InvoiceId,
        sum(UnitPrice) as TotalSaleValue
    from invoice_items
    group by InvoiceId
 )
 where Total != TotalSaleValue;

 -- Output
 Total       TotalSaleValue
 ----------  --------------
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 13.86       13.86
 ...
	select
	Total,
	TotalSaleValue
	from invoices
	natural join (
	select
	InvoiceId,
	sum(UnitPrice) as TotalSaleValue
	from invoice_items
	group by InvoiceId
	)
	where Total != TotalSaleValue;

	-- Output
	Total TotalSaleValue
	---------- --------------
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	13.86 13.86
	...