Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT invoices.InvoiceId, SUM(UnitPrice*Quantity)
- FROM
- invoices INNER JOIN invoice_items ON invoices.InvoiceId=invoice_items.InvoiceId
- WHERE BillingCountry='Poland'
- GROUP BY invoices.InvoiceId
- HAVING COUNT(*) > 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement