07. RPA-Customer-Segmentation.sql

 SELECT *
FROM users
LIMIT 20;

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

SELECT email, created_at
FROM users
WHERE created_at < '2017-05-01'
ORDER BY created_at;

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;