forked from Manzikevin/Database-Programming-Group-Assignment
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsample_window_output.txt
More file actions
44 lines (44 loc) · 2.64 KB
/
Copy pathsample_window_output.txt
File metadata and controls
44 lines (44 loc) · 2.64 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
doctor_name department_name total_revenue row_num_overall rank_overall dense_rank_overall percent_rank_overall rank_within_department
Claude Mugisha Orthopedics 221000.00 1 1 1 0.00 1
Marie Claire Nyirahabimana Cardiology 181000.00 2 2 2 0.25 1
Patrick Habimana Neurology 141000.00 3 3 3 0.50 1
Eric Nsengiyumva Cardiology 93000.00 4 4 4 0.75 2
Emmanuel Rugamba Pediatrics 87000.00 5 5 5 1.00 1
bill_id department_name bill_date amount running_total department_avg department_min department_max
1 Cardiology 2026-05-02 45000.00 45000.00 45666.67 38000.00 55000.00
2 Cardiology 2026-05-04 52000.00 97000.00 45666.67 38000.00 55000.00
3 Cardiology 2026-05-05 38000.00 135000.00 45666.67 38000.00 55000.00
4 Neurology 2026-05-06 61000.00 196000.00 47000.00 33000.00 61000.00
5 Neurology 2026-05-07 47000.00 243000.00 47000.00 33000.00 61000.00
6 Pediatrics 2026-05-08 29000.00 272000.00 29000.00 27000.00 31000.00
7 Pediatrics 2026-05-10 31000.00 303000.00 29000.00 27000.00 31000.00
8 Orthopedics 2026-05-11 72000.00 375000.00 73666.67 68000.00 81000.00
9 Orthopedics 2026-05-12 68000.00 443000.00 73666.67 68000.00 81000.00
10 Cardiology 2026-05-14 40000.00 483000.00 45666.67 38000.00 55000.00
11 Cardiology 2026-05-15 55000.00 538000.00 45666.67 38000.00 55000.00
12 Neurology 2026-05-16 33000.00 571000.00 47000.00 33000.00 61000.00
13 Pediatrics 2026-05-18 27000.00 598000.00 29000.00 27000.00 31000.00
14 Orthopedics 2026-05-19 81000.00 679000.00 73666.67 68000.00 81000.00
15 Cardiology 2026-06-05 44000.00 723000.00 45666.67 38000.00 55000.00
patient_name appointment_date amount previous_bill_amount next_bill_amount change_from_previous
Aline Umuhoza 2026-05-02 45000.00 NULL 27000.00 NULL
Aline Umuhoza 2026-05-18 27000.00 45000.00 NULL -18000.00
Bosco Niyonzima 2026-05-04 52000.00 NULL 81000.00 NULL
Bosco Niyonzima 2026-05-19 81000.00 52000.00 NULL 29000.00
Chantal Uwase 2026-05-05 38000.00 NULL NULL NULL
David Mugabo 2026-05-06 61000.00 NULL NULL NULL
Esperance Nyiraneza 2026-05-07 47000.00 NULL NULL NULL
Felix Rukundo 2026-05-08 29000.00 NULL NULL NULL
Gisele Mukashema 2026-05-10 31000.00 NULL NULL NULL
Hakizimana Jean Paul 2026-05-11 72000.00 NULL NULL NULL
Immaculee Ingabire 2026-05-12 68000.00 NULL 44000.00 NULL
Immaculee Ingabire 2026-06-05 44000.00 68000.00 NULL -24000.00
Jules Nkurunziza 2026-05-14 40000.00 NULL NULL NULL
Kevine Uwamahoro 2026-05-15 55000.00 NULL NULL NULL
Leon Byiringiro 2026-05-16 33000.00 NULL NULL NULL
doctor_name total_revenue performance_quartile cumulative_distribution
Claude Mugisha 221000.00 1 1.00
Marie Claire Nyirahabimana 181000.00 1 0.80
Patrick Habimana 141000.00 2 0.60
Eric Nsengiyumva 93000.00 3 0.40
Emmanuel Rugamba 87000.00 4 0.20