Project: RPA Customer Segmentation | Codecademy | Analyze data with SQL | 2. Writing basic queries | Extra practice

RPA_customer_segmentation.txt

SELECT *
FROM users
LIMIT 20;

SELECT email, birthday
FROM users
WHERE birthday BETWEEN '1980-01-01' AND '1989-12-31';

SELECT email, created_at
FROM users
WHERE created_at <= '2017-04-30';

SELECT email
FROM users
WHERE test = 'bears';

SELECT email
FROM users
WHERE campaign LIKE 'BBB%';

SELECT email
FROM users
WHERE campaign LIKE '%-2';

SELECT email
FROM users
WHERE campaign IS NOT NULL
  AND test IS NOT NULL;