D4BBK1Xh

1DROP TABLE IF EXISTS issue_metrics_table;
2CREATE TABLE IF NOT EXISTS issue_metrics_table (
3    domain TEXT NOT NULL,
4    issue_id TEXT NOT NULL,
5    created_at BIGINT NOT NULL,
6    inbound_count BIGINT,
7    outbound_count BIGINT,
8    csat INT
9);
10
11INSERT INTO issue_metrics_table VALUES('hscustomer','1',1000,100,50, 4);
12INSERT INTO issue_metrics_table VALUES('hscustomer','2',1001,100,50, 1);
13INSERT INTO issue_metrics_table VALUES('hscustomer','3',1002,200,150, 3);
14INSERT INTO issue_metrics_table VALUES('hscustomer','4',1003,200,150, 3);
15INSERT INTO issue_metrics_table VALUES('abc','5',1004,200,150, 3);
16
17DROP TABLE IF EXISTS agent_metrics_table;
18CREATE TABLE IF NOT EXISTS agent_metrics_table (
19    domain TEXT NOT NULL,
20    time_bucket TEXT NOT NULL,
21    agent_id TEXT NOT NULL,
22    ttfr_sum BIGINT,
23    ttfr_count BIGINT,
24    csat INT
25);
26
27INSERT INTO agent_metrics_table VALUES('hscustomer','201901010130',"a1",100,50, 4);
28INSERT INTO agent_metrics_table VALUES('hscustomer','201901010200',"a1",200,150, 3);
29INSERT INTO agent_metrics_table VALUES('hscustomer','201901010230',"a1",200,150, 3);
30INSERT INTO agent_metrics_table VALUES('hscustomer','201901010130',"a2",200,150, 3);
31INSERT INTO agent_metrics_table VALUES('hscustomer','201901010200',"a2",200,150, 5);
32INSERT INTO agent_metrics_table VALUES('abc','201901010230',"aa2",200,150, 3);