.header ON
.mode column
CREATE TABLE users (id INTEGER PRIMARY KEY, campaign TEXT, signed_up_on TEXT);
CREATE TABLE payments (id INTEGER PRIMARY KEY, amount INTEGER, paid_on TEXT, user_id INTEGER, FOREIGN KEY(user_id) REFERENCES users(id));
INSERT INTO users(id, campaign, signed_up_on) VALUES (1,  'facebook', '2014-10-01');
INSERT INTO users(id, campaign, signed_up_on) VALUES (2,  'twitter',  '2014-10-02');
INSERT INTO users(id, campaign, signed_up_on) VALUES (3,  'direct',   '2014-10-02');
INSERT INTO users(id, campaign, signed_up_on) VALUES (4,  'facebook',  '2014-10-03');
INSERT INTO users(id, campaign, signed_up_on) VALUES (5,  'organic', '2014-10-03');
INSERT INTO users(id, campaign, signed_up_on) VALUES (6,  'organic',  '2014-10-03');
INSERT INTO users(id, campaign, signed_up_on) VALUES (7,  'organic',  '2014-10-04');
INSERT INTO users(id, campaign, signed_up_on) VALUES (8,  'direct',   '2014-10-05');
INSERT INTO users(id, campaign, signed_up_on) VALUES (9,  'twitter',  '2014-10-05');
INSERT INTO users(id, campaign, signed_up_on) VALUES (10, 'organic',  '2014-10-05');
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (1, 1, '2014-10-02', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (2, 1, '2014-10-03', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (3, 1, '2014-10-04', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (4, 1, '2014-10-05', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (5, 1, '2014-10-06', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (6, 1, '2014-10-07', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (7, 1, '2014-10-08', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (8, 1, '2014-10-09', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (9, 1, '2014-10-10', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (10, 1, '2014-10-11', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (11, 1, '2014-10-12', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (12, 1, '2014-10-13', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (13, 1, '2014-10-14', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (14, 1, '2014-10-15', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (15, 1, '2014-10-16', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (16, 1, '2014-10-17', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (17, 1, '2014-10-18', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (18, 1, '2014-10-19', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (19, 1, '2014-10-20', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (20, 1, '2014-10-21', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (21, 1, '2014-10-22', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (22, 1, '2014-10-23', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (23, 1, '2014-10-24', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (24, 1, '2014-10-25', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (25, 1, '2014-10-26', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (26, 1, '2014-10-27', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (27, 1, '2014-10-28', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (28, 1, '2014-10-29', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (29, 1, '2014-10-30', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (30, 1, '2014-10-31', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (31, 2, '2014-10-03', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (32, 2, '2014-10-04', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (33, 2, '2014-10-05', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (34, 2, '2014-10-06', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (35, 2, '2014-10-07', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (36, 2, '2014-10-08', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (37, 2, '2014-10-09', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (38, 2, '2014-10-10', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (39, 2, '2014-10-11', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (40, 2, '2014-10-12', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (41, 2, '2014-10-13', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (42, 2, '2014-10-14', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (43, 2, '2014-10-15', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (44, 2, '2014-10-16', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (45, 2, '2014-10-17', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (46, 2, '2014-10-18', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (47, 2, '2014-10-19', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (48, 2, '2014-10-20', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (49, 2, '2014-10-21', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (50, 2, '2014-10-22', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (51, 2, '2014-10-23', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (52, 2, '2014-10-24', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (53, 2, '2014-10-25', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (54, 2, '2014-10-26', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (55, 2, '2014-10-27', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (56, 2, '2014-10-28', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (57, 2, '2014-10-29', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (58, 2, '2014-10-30', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (59, 2, '2014-10-31', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (60, 2, '2014-11-01', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (61, 3, '2014-10-05', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (62, 3, '2014-10-06', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (63, 3, '2014-10-12', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (64, 3, '2014-10-22', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (65, 3, '2014-10-26', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (66, 4, '2014-10-05', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (67, 4, '2014-10-06', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (68, 4, '2014-10-07', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (69, 4, '2014-10-08', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (70, 4, '2014-10-09', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (71, 4, '2014-10-18', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (72, 4, '2014-10-19', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (73, 4, '2014-10-24', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (74, 4, '2014-10-28', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (75, 4, '2014-11-01', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (76, 4, '2014-11-02', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (77, 5, '2014-10-06', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (78, 5, '2014-10-07', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (79, 5, '2014-10-09', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (80, 5, '2014-10-10', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (81, 5, '2014-10-11', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (82, 5, '2014-10-12', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (83, 5, '2014-10-14', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (84, 5, '2014-10-16', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (85, 5, '2014-10-18', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (86, 5, '2014-10-22', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (87, 5, '2014-10-28', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (88, 5, '2014-11-01', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (89, 5, '2014-11-02', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (90, 6, '2014-10-04', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (91, 6, '2014-10-05', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (92, 6, '2014-10-06', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (93, 6, '2014-10-07', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (94, 6, '2014-10-08', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (95, 6, '2014-10-09', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (96, 6, '2014-10-10', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (97, 6, '2014-10-11', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (98, 6, '2014-10-12', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (99, 6, '2014-10-13', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (100, 6, '2014-10-14', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (101, 6, '2014-10-15', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (102, 6, '2014-10-16', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (103, 6, '2014-10-17', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (104, 6, '2014-10-18', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (105, 6, '2014-10-19', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (106, 6, '2014-10-20', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (107, 6, '2014-10-21', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (108, 6, '2014-10-22', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (109, 6, '2014-10-23', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (110, 6, '2014-10-24', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (111, 6, '2014-10-25', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (112, 6, '2014-10-26', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (113, 6, '2014-10-27', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (114, 6, '2014-10-28', 50);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (115, 6, '2014-10-29', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (116, 6, '2014-10-30', 100);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (117, 6, '2014-10-31', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (118, 6, '2014-11-01', 30);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (119, 6, '2014-11-02', 40);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (120, 7, '2014-10-07', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (121, 7, '2014-10-12', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (122, 7, '2014-10-16', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (123, 7, '2014-10-17', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (124, 7, '2014-10-19', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (125, 7, '2014-10-22', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (126, 7, '2014-10-23', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (127, 7, '2014-10-25', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (128, 7, '2014-11-03', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (129, 8, '2014-10-06', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (130, 8, '2014-10-08', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (131, 8, '2014-10-10', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (132, 8, '2014-10-12', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (133, 8, '2014-10-24', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (134, 8, '2014-10-25', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (135, 8, '2014-10-28', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (136, 8, '2014-10-30', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (137, 8, '2014-10-31', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (138, 8, '2014-11-02', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (139, 9, '2014-10-09', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (140, 9, '2014-10-10', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (141, 9, '2014-10-13', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (142, 9, '2014-10-15', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (143, 9, '2014-10-18', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (144, 9, '2014-10-20', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (145, 9, '2014-10-22', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (146, 9, '2014-10-27', 5);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (147, 9, '2014-11-01', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (148, 9, '2014-11-02', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (149, 10, '2014-10-06', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (150, 10, '2014-10-07', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (151, 10, '2014-10-10', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (152, 10, '2014-10-14', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (153, 10, '2014-10-18', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (154, 10, '2014-10-26', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (155, 10, '2014-10-30', 10);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (156, 10, '2014-11-03', 20);
INSERT INTO payments(id, user_id, paid_on, amount) VALUES (157, 10, '2014-11-04', 5);