Skip to content

Instantly share code, notes, and snippets.

@mcewen87
Created May 21, 2022 20:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mcewen87/ad1600926d45a0e24dda88778fb665b6 to your computer and use it in GitHub Desktop.
Save mcewen87/ad1600926d45a0e24dda88778fb665b6 to your computer and use it in GitHub Desktop.
create table sales_rep_calls (
id INT,
sales_rep VARCHAR(6),
call_date DATE,
outcome VARCHAR(7),
client_id INT
);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (1, 'Ginger', '14-May-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (2, 'Robert', '05-Feb-2022', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (3, 'Javier', '13-Jul-2021', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (4, 'Robert', '09-May-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (5, 'Javier', '01-Nov-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (6, 'Robert', '01-Feb-2022', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (7, 'Javier', '20-Feb-2022', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (8, 'Ginger', '08-Jun-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (9, 'Paula', '15-May-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (10, 'Robert', '21-Jul-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (11, 'Robert', '29-Dec-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (12, 'Paula', '29-Nov-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (13, 'Paula', '12-Mar-2022', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (14, 'Ginger', '12-Dec-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (15, 'Robert', '26-Apr-2021', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (16, 'Paula', '31-Jul-2021', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (17, 'Ginger', '24-Aug-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (18, 'Paula', '01-Sep-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (19, 'Paula', '23-Apr-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (20, 'Ginger', '13-Aug-2021', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (21, 'Ginger', '13-Feb-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (22, 'Ginger', '17-Jul-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (23, 'Robert', '03-Jul-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (24, 'Paula', '25-Nov-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (25, 'Robert', '20-Jul-2021', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (26, 'Ginger', '04-Oct-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (27, 'Paula', '15-Apr-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (28, 'Ginger', '17-Jul-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (29, 'Robert', '26-Aug-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (30, 'Ginger', '13-Mar-2022', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (31, 'Ginger', '16-Jan-2022', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (32, 'Paula', '15-Oct-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (33, 'Javier', '22-May-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (34, 'Javier', '25-Nov-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (35, 'Robert', '29-Jul-2021', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (36, 'Paula', '21-May-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (37, 'Robert', '26-Dec-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (38, 'Robert', '30-Dec-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (39, 'Javier', '25-Dec-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (40, 'Ginger', '19-Nov-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (41, 'Javier', '15-Apr-2022', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (42, 'Robert', '01-Jun-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (43, 'Paula', '06-Jul-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (44, 'Robert', '04-Jun-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (45, 'Paula', '18-Oct-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (46, 'Paula', '21-Apr-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (47, 'Javier', '17-Oct-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (48, 'Ginger', '13-Feb-2022', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (49, 'Robert', '06-Apr-2022', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (50, 'Javier', '15-Apr-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (51, 'Javier', '25-Apr-2022', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (52, 'Javier', '21-Nov-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (53, 'Paula', '05-Jul-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (54, 'Robert', '14-May-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (55, 'Paula', '09-Sep-2021', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (56, 'Javier', '02-May-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (57, 'Robert', '05-Apr-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (58, 'Ginger', '15-Aug-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (59, 'Paula', '26-Dec-2021', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (60, 'Paula', '11-May-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (61, 'Paula', '22-Jun-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (62, 'Paula', '27-Sep-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (63, 'Ginger', '27-May-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (64, 'Paula', '07-Apr-2022', 'sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (65, 'Javier', '06-Apr-2022', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (66, 'Ginger', '28-Jun-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (67, 'Robert', '17-May-2021', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (68, 'Paula', '06-May-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (69, 'Robert', '23-Dec-2021', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (70, 'Robert', '01-Jun-2021', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (71, 'Ginger', '30-May-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (72, 'Ginger', '03-Oct-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (73, 'Paula', '16-Aug-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (74, 'Javier', '28-Oct-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (75, 'Javier', '28-Jan-2022', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (76, 'Ginger', '28-Jan-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (77, 'Ginger', '02-Apr-2022', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (78, 'Javier', '23-Apr-2021', 'sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (79, 'Robert', '23-Feb-2022', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (80, 'Javier', '11-Nov-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (81, 'Javier', '03-Apr-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (82, 'Robert', '29-Jun-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (83, 'Javier', '18-Jan-2022', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (84, 'Paula', '31-Mar-2022', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (85, 'Javier', '11-Oct-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (86, 'Paula', '18-Feb-2022', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (87, 'Paula', '03-Dec-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (88, 'Javier', '25-Jan-2022', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (89, 'Robert', '13-Mar-2022', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (90, 'Robert', '07-Sep-2021', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (91, 'Javier', '05-Mar-2022', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (92, 'Robert', '29-Mar-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (93, 'Javier', '02-Jul-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (94, 'Ginger', '31-Oct-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (95, 'Paula', '11-Jan-2022', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (96, 'Paula', '17-Apr-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (97, 'Robert', '16-Jan-2022', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (98, 'Paula', '08-Apr-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (99, 'Paula', '15-Mar-2022', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (100, 'Javier', '06-Jun-2021', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (101, 'Paula', '26-Aug-2021', 'sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (102, 'Ginger', '20-Dec-2021', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (103, 'Ginger', '25-Jan-2022', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (104, 'Ginger', '26-Sep-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (105, 'Paula', '15-Sep-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (106, 'Paula', '09-Oct-2021', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (107, 'Ginger', '21-Mar-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (108, 'Javier', '28-Nov-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (109, 'Paula', '01-Apr-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (110, 'Javier', '05-Jun-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (111, 'Javier', '04-Dec-2021', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (112, 'Javier', '29-Nov-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (113, 'Paula', '29-Dec-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (114, 'Robert', '14-Oct-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (115, 'Javier', '16-Jul-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (116, 'Paula', '01-Apr-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (117, 'Paula', '02-Oct-2021', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (118, 'Robert', '22-Mar-2022', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (119, 'Paula', '27-May-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (120, 'Ginger', '01-Oct-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (121, 'Javier', '13-Sep-2021', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (122, 'Paula', '19-Feb-2022', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (123, 'Paula', '09-Jan-2022', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (124, 'Javier', '16-Oct-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (125, 'Ginger', '12-Feb-2022', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (126, 'Javier', '01-Sep-2021', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (127, 'Ginger', '23-Apr-2022', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (128, 'Robert', '13-Dec-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (129, 'Ginger', '16-Mar-2022', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (130, 'Robert', '11-Jul-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (131, 'Ginger', '13-Apr-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (132, 'Ginger', '13-Aug-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (133, 'Robert', '14-Apr-2021', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (134, 'Paula', '30-Nov-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (135, 'Robert', '11-Apr-2022', 'sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (136, 'Robert', '03-Dec-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (137, 'Paula', '04-Aug-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (138, 'Robert', '14-Apr-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (139, 'Paula', '28-Feb-2022', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (140, 'Javier', '24-Nov-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (141, 'Paula', '22-Jan-2022', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (142, 'Javier', '01-Jun-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (143, 'Robert', '15-Mar-2022', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (144, 'Paula', '22-Nov-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (145, 'Paula', '08-Jan-2022', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (146, 'Javier', '31-Jan-2022', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (147, 'Paula', '26-Mar-2022', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (148, 'Ginger', '29-Jan-2022', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (149, 'Robert', '15-Sep-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (150, 'Javier', '21-Apr-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (151, 'Ginger', '02-Jul-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (152, 'Robert', '22-Aug-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (153, 'Ginger', '01-Aug-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (154, 'Ginger', '08-Feb-2022', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (155, 'Robert', '10-Sep-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (156, 'Ginger', '05-May-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (157, 'Javier', '14-Jun-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (158, 'Javier', '04-Apr-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (159, 'Ginger', '28-Apr-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (160, 'Ginger', '28-Mar-2022', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (161, 'Javier', '27-Oct-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (162, 'Javier', '16-Sep-2021', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (163, 'Paula', '01-Nov-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (164, 'Robert', '11-Jun-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (165, 'Ginger', '13-Jul-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (166, 'Paula', '26-May-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (167, 'Paula', '04-Aug-2021', 'sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (168, 'Javier', '06-Apr-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (169, 'Robert', '15-Mar-2022', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (170, 'Paula', '02-Feb-2022', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (171, 'Ginger', '07-Oct-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (172, 'Paula', '23-Nov-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (173, 'Robert', '22-Feb-2022', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (174, 'Javier', '24-Aug-2021', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (175, 'Paula', '06-May-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (176, 'Javier', '07-Aug-2021', 'no sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (177, 'Ginger', '16-Jan-2022', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (178, 'Robert', '27-Nov-2021', 'no sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (179, 'Javier', '23-May-2021', 'no sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (180, 'Robert', '27-Apr-2022', 'no sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (181, 'Javier', '29-Apr-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (182, 'Robert', '02-Aug-2021', 'no sale', 6);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (183, 'Ginger', '07-Oct-2021', 'sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (184, 'Robert', '15-Oct-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (185, 'Javier', '19-Aug-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (186, 'Javier', '19-Mar-2022', 'no sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (187, 'Ginger', '10-Jul-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (188, 'Paula', '17-Jan-2022', 'sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (189, 'Robert', '15-Jan-2022', 'no sale', 9);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (190, 'Javier', '11-Oct-2021', 'no sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (191, 'Ginger', '05-Apr-2021', 'sale', 5);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (192, 'Paula', '29-May-2021', 'sale', 3);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (193, 'Ginger', '06-Aug-2021', 'no sale', 4);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (194, 'Robert', '29-Nov-2021', 'sale', 10);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (195, 'Paula', '05-Sep-2021', 'no sale', 1);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (196, 'Paula', '28-Feb-2022', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (197, 'Ginger', '13-Sep-2021', 'sale', 2);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (198, 'Ginger', '11-Sep-2021', 'sale', 7);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (199, 'Ginger', '02-Feb-2022', 'sale', 8);
insert into sales_rep_calls (id, sales_rep, call_date, outcome, client_id) values (200, 'Paula', '29-Apr-2021', 'sale', 5);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment