RPA Customer Segmentation

test.sql

--1

SELECT *
FROM users
LIMIT 20;

--id, email, campaign, test, created_at, birthday

--2 

SELECT email, birthday
FROM users
where birthday between '1980-01-01' and '1989-12-31';

--3

SELECT email, created_at
FROM users
where created_at < '2017-04-30' 
limit 5;

--4

SELECT *
FROM users
where test = 'bears';

--5

SELECT *
FROM users
where campaign like 'BBB%';

--6

SELECT *
FROM users
where campaign like '%-2';

--7

SELECT *
FROM users
where campaign IS NOT NULL AND test IS NOT NULL;