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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
/*
Created by: Ihor Semeniuk
Create Date: 08/12/2023
Decscription: Creating Mailing list of US Custumers
*/
SELECT
	FirstName,
    LastName,
    `Address`,
    FirstName || ' ' || LastName || ' ' || Address || ', ' || City || ' ' || State || '' || PostalCode AS [Mailing Adres]
FROM
	Customer
WHERE
    Country = 'USA';