--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.16
-- Dumped by pg_dump version 9.5.16

-- Started on 2019-05-03 16:56:41

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 1 (class 3079 OID 12355)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 2104 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 183 (class 1259 OID 66219)
-- Name: dmemp; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.dmemp (
    student_id bigint,
    session_id bigint,
    duration double precision,
    total double precision,
    session_points double precision
);


ALTER TABLE public.dmemp OWNER TO postgres;

--
-- TOC entry 2095 (class 0 OID 66219)
-- Dependencies: 183
-- Data for Name: dmemp; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.dmemp (student_id, session_id, duration, total, session_points) FROM stdin;
1	6	10631	94.5	2.25
1	2	8603	94.5	5
1	5	6872	94.5	4
1	4	5197	94.5	4.5
1	1	6574	94.5	0
2	5	5263	44	4
2	4	4278	44	4.5
2	3	9831	44	3.5
2	6	6029	44	1
2	1	4462	44	0
2	2	8723	44	4
3	4	5285	85	4.5
3	2	8325	85	3.5
3	5	5543	85	4
3	3	9278	85	3.5
4	4	2937	30	5
4	3	10168	30	4
4	6	10434	30	2.75
4	5	5438	30	3.5
4	2	8631	30	6
4	1	4867	30	0
5	3	8667	38.5	4
5	1	4980	38.5	0
5	6	9382	38.5	2.75
5	2	7937	38.5	5
5	5	5139	38.5	4
5	4	3437	38.5	5
6	5	6592	82	3
6	2	8432	82	5.5
6	6	9025	82	3
6	4	4570	82	4.5
6	3	9548	82	3.5
7	5	3751	78	4
7	6	9278	78	2
7	2	8449	78	4
7	1	5355	78	0
7	3	9492	78	4
7	4	4955	78	4.5
8	5	4993	8.5	3
8	4	2663	8.5	4
8	2	8714	8.5	4
8	3	9395	8.5	3.5
9	1	3222	18.5	0
9	3	8458	18.5	3
9	4	3402	18.5	4
9	6	10270	18.5	2
9	5	6238	18.5	4
10	5	5463	59	4
10	2	7978	59	5
10	6	9313	59	3
10	3	8641	59	4
10	1	5157	59	0
10	4	5204	59	4.5
11	2	9129	60	4
11	5	4118	60	4
11	4	2762	60	5
11	6	9471	60	1.5
11	3	10255	60	2
11	1	5809	60	0
12	6	10300	40.5	2
12	1	5702	40.5	0
12	3	8676	40.5	3.5
12	4	4721	40.5	4.5
12	2	7914	40.5	3.5
12	5	6964	40.5	4
13	6	8761	90	3
13	5	7444	90	4
13	4	4318	90	5
14	4	4468	64	5
14	1	6491	64	0
14	5	5198	64	4
14	2	8278	64	6
14	3	8939	64	4
14	6	9418	64	2.75
15	1	5474	67.5	0
15	6	9410	67.5	2
15	3	9733	67.5	4
15	5	3587	67.5	4
15	4	3126	67.5	5
15	2	7608	67.5	2
16	4	3006	67	5
16	6	9449	67	2
16	3	9072	67	2.5
16	2	7993	67	3
16	5	3983	67	4
17	2	8625	97	3.5
17	5	6957	97	4
17	3	9303	97	3.5
17	4	5433	97	5
17	1	1425	97	0
17	6	8878	97	4
18	6	10446	62	3
18	2	7054	62	5
18	3	10620	62	4
18	5	4417	62	4
18	4	6300	62	4.5
19	4	4100	50	4.5
19	2	9689	50	4
19	5	5663	50	4
19	6	9550	50	1.5
19	3	10690	50	2
19	1	4228	50	0
20	1	6655	97.5	0
20	5	6214	97.5	3.5
20	4	4065	97.5	4.5
20	3	9145	97.5	3
20	2	8069	97.5	3
20	6	10248	97.5	2
21	2	9328	0	5
21	1	3867	0	0
21	4	6873	0	3.5
22	1	5045	40	0
22	2	9287	40	4.5
22	4	3056	40	4
22	5	6501	40	4
23	3	7878	0	1.5
23	4	3695	0	4
23	5	5801	0	3.5
24	4	3323	70.5	4.5
24	6	8891	70.5	3
24	3	11057	70.5	2
24	5	6544	70.5	3.5
24	2	9054	70.5	2.5
25	4	5149	57.5	4.5
25	3	10810	57.5	1.5
25	6	11203	57.5	2.25
26	4	3329	0	4
27	5	5306	74.5	4
27	2	11800	74.5	0
27	4	2922	74.5	4.5
27	6	9265	74.5	1.75
27	3	9437	74.5	3
28	6	10480	79.5	3
28	5	4692	79.5	4
28	2	9063	79.5	6
28	4	6128	79.5	5
28	3	10339	79.5	4
28	1	2867	79.5	0
29	4	3909	97	5
29	3	9972	97	3
29	5	4738	97	4
29	6	8786	97	3.75
29	2	7771	97	4
30	2	8298	55.5	3
30	3	10507	55.5	2
30	4	5721	55.5	4.5
30	1	6255	55.5	0
30	6	10040	55.5	2.75
30	5	5978	55.5	4
31	3	9134	0	0.5
31	4	2836	0	4
31	5	3720	0	3
32	6	8707	75.5	3.5
32	1	5260	75.5	0
32	5	6278	75.5	4
32	3	8641	75.5	4
32	4	5296	75.5	5
32	2	7854	75.5	5.5
33	4	4623	30.5	4
34	4	4532	18	5
34	5	5240	18	3
34	2	8185	18	4.5
34	6	5442	18	1.25
34	3	9664	18	3.5
34	1	3715	18	0
35	6	9816	0	1.5
35	3	9827	0	0.5
35	4	4946	0	3.5
35	5	7606	0	3.5
36	3	10733	79	4
36	6	10561	79	2.75
36	1	4510	79	0
36	5	5220	79	4
36	2	8514	79	5.5
36	4	5879	79	5
37	6	7808	30	3
37	5	6380	30	3.5
37	4	4450	30	4.5
37	1	4678	30	0
38	2	8822	41.5	4
38	6	8692	41.5	3
38	4	3498	41.5	4.5
38	3	11363	41.5	2.5
38	1	5990	41.5	0
38	5	5071	41.5	3.5
39	2	8817	83.5	3
39	5	6576	83.5	3.5
39	3	8812	83.5	1
39	1	5749	83.5	0
39	4	4629	83.5	4.5
39	6	9474	83.5	2.5
40	5	6614	0	2.5
40	4	4323	0	3
41	4	4873	98	5
41	5	4025	98	4
41	6	10929	98	3.25
41	2	7521	98	5.5
41	3	9265	98	4
42	6	11337	22.5	1.5
42	5	7936	22.5	4
42	3	10038	22.5	2.5
42	1	5888	22.5	0
42	2	9392	22.5	3
42	4	7757	22.5	4
43	2	8392	0	4.5
43	4	5041	0	4.5
43	1	6154	0	0
43	3	9760	0	2.5
44	1	3805	97.5	0
44	5	6375	97.5	4
44	6	9751	97.5	3
44	4	4717	97.5	4.5
44	3	8392	97.5	4
44	2	8631	97.5	5.5
45	4	4937	46	4.5
45	3	10007	46	1
45	5	6059	46	2.5
46	1	7408	22	0
46	6	9070	22	1
46	2	7994	22	2
46	4	5466	22	4
47	2	8309	28	4
47	4	4461	28	4
47	1	5516	28	0
47	3	10385	28	2
47	5	11269	28	2.5
47	6	9269	28	0.25
48	5	5700	71.5	4
48	4	3421	71.5	4.5
48	3	9650	71.5	2.5
48	2	8054	71.5	3.5
48	6	10474	71.5	2.5
49	6	10118	30.5	2.75
49	4	3807	30.5	4.5
49	5	4270	30.5	3.5
49	2	8508	30.5	3
49	3	10603	30.5	2.5
49	1	5138	30.5	0
50	3	9988	0	2
50	4	6237	0	4
50	6	7967	0	1.5
50	5	7925	0	3.5
50	2	7020	0	2
51	4	5516	9	4
51	3	9400	9	1
51	2	8596	9	1
51	1	6549	9	0
51	5	4445	9	4
51	6	9181	9	0.5
52	4	4250	36	5
52	6	9177	36	2.25
52	1	5033	36	0
52	3	8673	36	4
52	5	5380	36	4
52	2	8644	36	6
53	3	10634	70.5	3
53	6	9972	70.5	3
53	2	8616	70.5	4
53	5	4284	70.5	3.5
53	1	5198	70.5	0
53	4	5224	70.5	4.5
54	2	8169	39	4.5
54	5	5345	39	3.5
54	3	9706	39	3.5
54	1	4190	39	0
54	6	5266	39	0.75
54	4	4698	39	4.5
55	5	5029	36.5	4
55	3	10288	36.5	3.5
55	1	6390	36.5	0
55	4	5834	36.5	4.5
56	1	5206	84	0
56	3	7163	84	3
56	2	7526	84	2.5
56	6	9594	84	3
56	4	4748	84	4.5
56	5	5848	84	3
57	6	9523	23	2.75
57	4	4626	23	4.5
58	4	4853	48	4.5
59	5	6038	40	3.5
59	6	8097	40	2
59	3	9236	40	2
59	2	9053	40	3.5
59	4	3994	40	4
59	1	4845	40	0
60	5	7698	16.5	3.5
60	4	4615	16.5	4
60	6	8261	16.5	1
61	4	2775	57.5	4.5
61	3	10830	57.5	1
61	6	9138	57.5	1.5
61	5	7516	57.5	3.5
61	2	7120	57.5	0
62	4	2887	43	4
62	1	5432	43	0
63	6	9417	69	1
63	2	8380	69	3.5
63	4	7323	69	5
63	3	10133	69	1.5
63	1	5837	69	0
63	5	6155	69	3.5
64	4	3749	20.5	4
64	6	9017	20.5	1.5
64	5	7224	20.5	3.5
65	5	6808	0	3.5
65	6	9149	0	1.5
65	4	4861	0	4
66	3	7498	86	2
66	2	14738	86	0
66	4	1611	86	4.5
66	1	3481	86	0
66	5	5563	86	3
66	6	10510	86	2.25
67	1	4234	92	0
67	6	7270	92	2.75
67	3	8166	92	4
67	4	3540	92	4.5
67	2	8948	92	5.5
67	5	6189	92	4
68	4	5910	91	5
68	1	5386	91	0
68	3	8220	91	3.5
68	6	10257	91	3
68	5	4795	91	4
69	3	7991	23.5	0.5
69	6	8313	23.5	2
69	5	7961	23.5	4
69	4	4811	23.5	4
70	2	8701	60.5	5.5
70	1	4340	60.5	0
70	5	4051	60.5	4
70	3	8781	60.5	4
70	6	10726	60.5	3.25
70	4	4670	60.5	5
71	2	8752	90.5	5
71	1	3496	90.5	0
71	4	2905	90.5	5
71	5	4268	90.5	3.5
72	5	5798	95	3.5
72	6	7294	95	2.75
72	4	4807	95	4
72	3	7930	95	3
72	2	8479	95	4.5
73	4	4519	49	4
73	3	8855	49	3
73	6	7828	49	2
73	2	8904	49	4.5
73	1	5118	49	0
74	3	9784	18	1.5
74	2	8517	18	3
74	5	4694	18	4
74	6	9185	18	1.75
74	4	5196	18	5
74	1	7662	18	0
75	3	9809	87.5	4
75	4	2707	87.5	5
75	5	3704	87.5	4
75	6	9570	87.5	2
76	2	6487	93.5	4
76	1	5022	93.5	0
76	4	5374	93.5	4
76	3	8674	93.5	4
76	6	7694	93.5	2
76	5	4970	93.5	4
77	4	4720	66.5	4
78	3	9943	78	3
78	6	9173	78	2.75
78	1	4843	78	0
78	5	5355	78	4
78	2	6678	78	2.5
78	4	4252	78	5
79	2	8984	84.5	5
79	5	7056	84.5	4
79	1	5039	84.5	0
79	4	3863	84.5	4.5
79	3	9910	84.5	3.5
79	6	9899	84.5	2.75
80	2	9067	51.5	3.5
80	3	10723	51.5	1
80	6	11245	51.5	2.5
80	5	6148	51.5	4
80	1	5982	51.5	0
80	4	3044	51.5	5
81	3	8740	87	4
81	4	3398	87	5
81	6	8838	87	2.75
81	1	4369	87	0
81	5	4405	87	4
81	2	7975	87	5
82	3	9872	13.5	2.5
82	5	5052	13.5	3.5
82	2	8683	13.5	2.5
82	4	3902	13.5	4
82	6	9183	13.5	1.5
82	1	5308	13.5	0
83	3	8804	52	2.5
83	4	3692	52	4.5
83	5	3705	52	4
83	6	9370	52	2
83	2	8058	52	4
84	4	5011	0	4.5
84	3	8897	0	0
84	2	7609	0	2.5
85	6	9340	82	4
85	1	4070	82	0
85	3	9836	82	4
85	4	3774	82	5
85	2	8713	82	6
85	5	5504	82	4
86	6	8811	94	3.25
86	1	4439	94	0
86	2	7781	94	5
86	3	8609	94	4
86	4	5433	94	5
86	5	6087	94	4
87	1	4904	74.5	0
87	4	5218	74.5	4.5
87	3	8773	74.5	3.5
87	6	9493	74.5	2.25
87	5	6393	74.5	3.5
87	2	9006	74.5	4
88	3	10251	96	3
88	5	6169	96	4
88	4	6174	96	5
88	1	4819	96	0
88	2	7872	96	5
88	6	9121	96	2.75
89	4	9229	16.5	3.5
89	3	7336	16.5	1.5
89	5	3201	16.5	2.5
89	6	9872	16.5	0.5
90	2	8602	0	3.5
90	5	5695	0	3.5
90	4	3176	0	4.5
90	1	3717	0	0
90	6	7141	0	3
90	3	11108	0	2.5
91	3	9190	66.5	4
91	2	8708	66.5	6
91	1	5950	66.5	0
91	4	4473	66.5	5
91	5	5226	66.5	4
91	6	9858	66.5	2.25
92	1	6156	35	0
92	4	5506	35	4.5
92	6	9683	35	1
92	2	8968	35	2.5
92	5	6261	35	4
92	3	9977	35	2.5
93	2	7816	66	4
93	4	2945	66	4.5
93	6	9509	66	1.5
93	5	5219	66	4
93	3	9328	66	4
93	1	4162	66	0
94	3	8732	92.5	4
94	2	8245	92.5	5.5
94	5	5183	92.5	4
94	4	4388	92.5	5
94	1	5728	92.5	0
94	6	9611	92.5	2.75
95	2	9803	52.5	4
95	4	3817	52.5	5
95	3	9559	52.5	3.5
95	6	10677	52.5	3.25
95	5	7868	52.5	3
96	1	5439	77.5	0
96	2	7583	77.5	4.5
96	6	9366	77.5	2.25
96	4	4671	77.5	5
96	5	5117	77.5	4
97	2	9002	0	4
97	4	5052	0	4.5
97	3	9439	0	3
97	1	3952	0	0
97	6	5666	0	0.5
98	6	9498	66.5	3
98	5	4317	66.5	4
98	1	5950	66.5	0
98	4	5172	66.5	5
98	3	10705	66.5	4
98	2	3890	66.5	3.5
99	5	6067	17	3.5
99	6	9475	17	1.5
99	2	8166	17	2
99	3	9468	17	2.5
99	4	4122	17	4
100	3	9064	83	2
100	2	7586	83	3.5
100	5	5116	83	4
100	1	5898	83	0
101	2	8512	32	4.5
101	1	5887	32	0
101	5	4248	32	3.5
101	3	10619	32	1.5
102	6	7704	31.5	2
102	2	7567	31.5	4.5
102	1	4960	31.5	0
102	5	4617	31.5	3.5
102	3	8645	31.5	4
103	2	8533	18.5	2
103	5	6825	18.5	3.5
104	2	7501	92	6
104	6	8905	92	2.75
104	1	5129	92	0
104	5	4244	92	4
105	1	4812	0	0
105	3	7492	0	0.5
106	3	8090	71	3.5
107	3	11561	0	1
107	2	13487	0	0
108	1	6446	0	0
109	1	6218	0	0
110	1	4532	0	0
111	1	5530	0	0
112	1	5419	0	0
113	1	7161	0	0
114	1	6381	0	0
115	1	6393	0	0
\.


--
-- TOC entry 2103 (class 0 OID 0)
-- Dependencies: 6
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2019-05-03 16:56:41

--
-- PostgreSQL database dump complete
--
