repeating-sql/select-from-invoice-5.4.sql at main · Bujhm/repeating-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
/*
Created by: Ihor Semeniuk
Create Date: 07/12/2023
Decscription: How many invoices were billed to Brussels. And another requirement --> Brussels, Orlando or Paris?
*/
SELECT
	i.CustomerId,
	i.InvoiceDate,
	i.BillingAddress,
	i.BillingCity,
	i.total
FROM
	Invoice AS i
WHERE
	-- i.BillingCity = 'Brussels'
	i.BillingCity IN ('Brussels','Orlando','Paris')

ORDER BY i.CustomerId