# Name Email Major Grade IP
1afasbbb@abc.comDigital Media10024.125.138.102
2rrrrrrrbbb@abc.comSecurity2524.125.138.102
3wwwwweeee@abc.comOther7524.125.138.102
4dfgslai@ggc.eduBusiness5024.125.138.102
5johnasdf@hotmail.comSoftware50168.28.22.146
6Some Guyinternet@internet.comBusiness100168.28.22.146
7Alex Buiinspiritsj93@gmail.comDigital Media100168.28.22.146
8asdfasdf@ggc.eduDigital Media050.147.203.70
9asdfasdf@ggc.eduDigital Media2550.147.203.70
10asdfasdf@ggc.eduDigital Media2550.147.203.70
11sdfasdf@ggc.eduDigital Media2550.147.203.70
12sdfasdf@ggc.eduDigital Media2550.147.203.70
13asdfasdf@ggc.eduDigital Media10050.147.203.70
14asdfasdf@ggc.eduSoftware050.147.203.70
15asdfasdf@ggc.eduDigital Media050.147.203.70
16asdfasdf@ggc.eduBusiness050.147.203.70
17asdfasdf@ggc.eduSecurity10050.147.203.70
18Carloscmunoz1@ggc.eduDigital Media100168.28.22.146
19Carloscmunoz1@ggc.eduDigital Media75168.28.22.146
20Carloscmunoz1@ggc.eduDigital Media50168.28.22.146
21Dudewho@gmail.comDigital Media75168.28.22.146
22Dudewho@gmail.comDigital Media100168.28.22.146
23helloggg@ggc.eduDigital Media50168.28.22.146
24helloggg@ggc.eduDigital Media50168.28.22.146
25carloscmunoz1@ggc.eduDigital Media100168.28.22.146
26carloscmunoz1@ggc.eduDigital Media75168.28.22.146
27carloscmunoz1@ggc.eduDigital Media75168.28.22.146
28carloscmunoz1@ggc.eduDigital Media0168.28.22.146
29carloscmunoz1@ggc.eduDigital Media0168.28.22.146
30Alvinajean1@ggc.eduDigital Media2567.191.235.51
31Alvinajean1@ggc.eduDigital Media10067.191.235.51
32carloscmunoz1@ggc.eduDigital Media099.141.154.74
33carloscmunoz1@ggc.eduDigital Media2599.141.154.74
34asdasdainspiritsj93@gmail.comSecurity098.192.41.27
35asdasdainspiritsj93@gmail.comSecurity098.192.41.27
36asdasdainspiritsj93@gmail.comSecurity10098.192.41.27
37Cameronirishfire777@gmail.comDigital Media10024.98.54.89
38Cameronirishfire777@gmail.comDigital Media024.98.54.89
39Cameronirishfire777@gmail.comDigital Media7524.98.54.89
40Cameronirishfire777@gmail.comDigital Media7524.98.54.89
41Cameronirishfire777@gmail.comDigital Media10024.98.54.89
42Cameronirishfire777@gmail.comDigital Media10024.98.54.89
43Cameronirishfire777@gmail.comDigital Media024.98.54.89
44Cameronirishfire777@gmail.comDigital Media024.98.54.89
45Karl Krausjedikarlkraus@bellsouth.netSoftware100108.74.190.25
46Karl Krausjedikarlkraus@bellsouth.netSoftware75108.74.190.25
47Karl Krausjedikarlkraus@bellsouth.netSoftware50108.74.190.25
48testtest@test.comDigital Media01.23.124.249
49testtest@test.comDigital Media251.23.124.249
50ertyuiabc@ggc.eduBusiness100172.56.5.105
51Fahd Quadrifquadri@ggc.eduDigital Media100172.56.4.213
52Cameronirishfire777@gmail.comDigital Media050.200.84.128
53Karl Krausjedikarlkraus@bellsouth.netSoftware50108.74.190.25
54samsmedina2@ggc.eduOther100168.28.22.10
55foh@ggc.eduDigital Media0168.28.2.98
56ertyuiabc@ggc.eduDigital Media0172.56.5.190
57ladjkadjlkadsjdlkskksdjk@ggc.eduDigital Media25168.28.22.41
58ladjkadjlkadsjdlkskksdjk@ggc.eduSoftware100168.28.22.41
59abcabc@ggc.eduDigital Media75168.28.2.98
60<span style="color:red">Someone</span>mail@ggc.comDigital Media0168.28.22.59
61asdfasabc@ggc.eduDigital Media0168.28.22.26
62Samuel CHangsam_Chang_79@yahoo.comDigital Media75168.28.22.36
63Samuel CHangsam_Chang_79@yahoo.comOther75168.28.22.36
64abcabc@ggc.eduDigital Media0168.28.22.26
65asdfaabc@ggc.eduDigital Media0168.28.22.26
66sometest@test.comsometest@test.comSoftware501.22.194.167
67sadfaasd@ggc.eduDigital Media2550.167.67.245
68sadfaasd@ggc.eduSecurity2550.167.67.245
69Jacobjfagan@ggc.eduSoftware100168.28.22.40
70Devora Lorenzodevora.lorenzo@yahoo.comDigital Media25168.28.22.44
71potatopotato@mail.comDigital Media50168.28.22.103
72Devora Lorenzodevora.lorenzo@yahoo.comDigital Media0168.28.22.44
73Dudewho@gmail.comDigital Media100168.28.22.34
74Dudewho@gmail.comDigital Media0168.28.22.34
75testtest@test.comSoftware01.22.88.169
76testtest@test.comSoftware01.22.88.169
77asdfaabc@ggc.eduDigital Media0168.28.22.120
78Rodny Josephrodnyjoseph92@gmail.comDigital Media2524.99.50.110
79kuhkurodnyjoseph92@gmail.comDigital Media024.99.50.110
80kuhkurodnyjoseph92@gmail.comDigital Media024.99.50.110
81kuhkurodnyjoseph92@gmail.comDigital Media2524.99.50.110
82kuhkurodnyjoseph92@gmail.comDigital Media5024.99.50.110
83kuhkurodnyjoseph92@gmail.comDigital Media5024.99.50.110
84dfgdfdfgdfg@dgd.comSoftware024.159.127.238
85Travis Keatingtkeating@ggc.eduDigital Media2596.32.85.89
86sfdfdsdf@ggc.eduDigital Media024.99.247.234
87sfdfdsdf@ggc.eduDigital Media024.99.247.234
88sdfjgdfg@gfdg.comDigital Media1004.15.179.163
89gokuvirginia@saiyan.popoDigital Media096.231.195.176
90sdfjgdfg@gfdg.comDigital Media1004.15.179.163
91sdfjgdfg@gfdg.comDigital Media1004.15.179.163
92sdflokinkl@fff.comDigital Media1004.15.179.163
93gokuui@live.comDigital Media096.231.195.176
94sdflokinkl@fff.comDigital Media10050.167.67.245
95sdflokinkl@fff.comDigital Media10050.167.67.245
96Bria Riversbrivers@ggc.eduDigital Media10024.125.233.10
97sdflokinkl@fff.comDigital Media10050.167.67.245
98gokuui@live.comDigital Media5096.231.195.176
99Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
100Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
101Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
102Jack Cantrelladhk@gmail.comDigital Media10050.160.207.11
103jackjcantr13@gmail.comDigital Media10050.160.207.11
104Karl Krausjedikarlkraus@bellsouth.netDigital Media0168.28.22.86
105Karl Krausjedikarlkraus@bellsouth.netDigital Media0168.28.22.86
106Karl Krausjedikarlkraus@bellsouth.netDigital Media25168.28.22.86
107dfgdfghj@ghj.comDigital Media100168.28.16.100
108Karinawho@gmail.comOther100168.28.22.34
109sdflokinkl@fff.comDigital Media100168.28.2.98
110asdfasdf@ghjkl.comSoftware10024.159.127.238
111Dudewho@gmail.comDigital Media100168.28.22.34
112Dudewho@gmail.comDigital Media100168.28.22.34
113RebeccaR@ggc.eduDigital Media2571.204.64.171
114Rebecca Tendeanrtendean@ggc.eduDigital Media071.204.64.171
115Rebecca Tendeanrtendean@ggc.eduDigital Media071.204.64.171
116Rebecca Tendeanrtendean@ggc.eduDigital Media2571.204.64.171
117Rebecca Tendeanrtendean@ggc.eduDigital Media2571.204.64.171
118Harry Pottergryffindor@hogwarts.eduSoftware10071.204.64.171
119sdflokinkl@fff.comDigital Media10050.167.67.245
120sdflokinkl@fff.comDigital Media10050.167.67.245
121sdflokinkl@fff.comDigital Media10050.167.67.245
122abcabc@ttt.comDigital Media25168.28.2.98
123abcabc@ttt.comDigital Media25168.28.2.98
124abcabc@ttt.comDigital Media25168.28.2.98
125john joefdsa@asdf.comDigital Media75168.28.22.88
126Fakename@ggc.eduDigital Media50168.28.22.58
127Joejoe@gmail.comDigital Media0168.28.22.93
128Miguellol@hotmail.comDigital Media100168.28.22.96
129Mikeme@email.comSoftware100168.28.22.50
130Fakelcopas@ggc.eduDigital Media75168.28.22.58
131Fakelcopas@ggc.eduDigital Media100168.28.22.58
132Joejoe@gmail.comDigital Media0168.28.22.93
133Mikeme@email.comSoftware100168.28.22.50
134jeffemail@email.comSoftware100168.28.22.55
135abfafda@ggc.eduDigital Media0168.28.2.98
136john joefdsa@asdf.comDigital Media75168.28.22.88
137Gloria Alvarengagalvaren@ggc.eduDigital Media100168.28.22.49
138matthewasda@ggc.eduBusiness75168.28.22.49
139Precious Westpwest1@ggc.eduDigital Media75168.28.22.87
140Mikeme@email.comSoftware100168.28.22.50
141Arthurarthur@ggc.eduDigital Media0173.15.220.177
142Jeff Gjeff.graves43@gmail.comSoftware2565.5.11.253
143aasdf@a.comBusiness2569.15.227.126
144aasdf@a.comBusiness2569.15.227.126
145aasdf@a.comBusiness2569.15.227.126
146YMENGMENG@GGC.EDUDigital Media25168.28.2.98
147adsa@da.comDigital Media0107.167.116.228
1484r4we@gm.eduDigital Media0168.28.16.100
1494r4we@gm.eduDigital Media0168.28.16.100
150erg@ggc.eduDigital Media2596.32.85.3
151adfadsf@ggc.eduDigital Media50168.28.22.108
152asdfadsasdfadsf@gedfjg.casdSecurity75168.28.22.108
153ww@w.fDigital Media0168.28.22.96
154aefwe@ffc.dfgDigital Media073.207.104.73
155aa@a.comDigital Media024.125.222.199
156dfgsdfg@something.eduSecurity2597.81.103.76
157King Orugakingoruga@aol.comSoftware10050.167.235.114
158King Orugakingoruga@aol.comSoftware7550.167.235.114
159King Orugakingoruga@aol.comSoftware7550.167.235.114
160dsfadfawe@fsdv.edaDigital Media073.207.104.73
161dsfadfawe@fsdv.edaDigital Media10073.207.104.73
162Christancdeluna@ggc.eduSoftware100157.166.173.5
163Chrischris@ggc.eduDigital Media50157.166.173.5
164Chrischris@ggc.eduDigital Media50157.166.173.5
165Chrischris@ggc.eduDigital Media75157.166.173.5
166jay dizzlejguyen7@ggc.eduDigital Media25168.28.22.95
167jay dizzlejguyen7@ggc.eduDigital Media25168.28.22.95
168jay winjnguyen@ggc.eduDigital Media2571.90.222.117
169jay winjnguyen@ggc.eduDigital Media071.90.222.117
170Joe Coxjcox8588@gmail.comDigital Media25159.63.144.227
171Joe Coxjcox8588@gmail.comDigital Media25159.63.144.227
172Joe Coxjcox8588@gmail.comDigital Media0159.63.144.227
173blakeadslfk@ge.comDigital Media7597.67.171.34
174blakeadslfk@ge.comDigital Media7597.67.171.34
175markmark@ggc.eduDigital Media0168.28.22.83
176markmark@ggc.eDigital Media0168.28.22.83
177markmark@ggc.eSecurity25168.28.22.83
178markmark@ggc.eSecurity50168.28.22.83
179Adam Printzprintzadam@f.comDigital Media0168.28.22.104
180Adam Printzprintzadam@f.comDigital Media0168.28.22.104
181Margaret Musemmuse@ggc.eduDigital Media25168.28.22.108
182markmark@ggc.eSecurity100168.28.22.83
183Precious Westpwest1@ggc.eduDigital Media25168.28.22.105
184Jim Coburnjimrcoburn@gmail.comDigital Media100168.28.22.32
185dwddwd@ggc.eduDigital Media100168.28.22.32
186Carlanchenry2@ggc.eduSoftware50168.28.22.108
187Carlanchenry2@ggc.eduSoftware50168.28.22.108
188Carlanchenry2@ggc.eduDigital Media75168.28.22.108
189Jim Coburnjimrcoburn@gmail.comDigital Media100168.28.22.32
190mikign@i.comDigital Media50168.28.22.100
191222ytuvb@ggc.eduDigital Media5075.131.196.162
192Miguela@a.comDigital Media075.131.192.68
193Miguela@a.comDigital Media075.131.192.68
194Dudeuiorweiot@gmail.comDigital Media83168.28.2.98
195Dudebbb@abc.comasdffffff8124.125.138.5
Totally195 rows.

There are totally 11 students in the Security major

Find all students of Digital Media major and having 100 points:
# Name Email Major Grade IP
1afasbbb@abc.comDigital Media10024.125.138.102
7Alex Buiinspiritsj93@gmail.comDigital Media100168.28.22.146
13asdfasdf@ggc.eduDigital Media10050.147.203.70
18Carloscmunoz1@ggc.eduDigital Media100168.28.22.146
22Dudewho@gmail.comDigital Media100168.28.22.146
25carloscmunoz1@ggc.eduDigital Media100168.28.22.146
31Alvinajean1@ggc.eduDigital Media10067.191.235.51
37Cameronirishfire777@gmail.comDigital Media10024.98.54.89
41Cameronirishfire777@gmail.comDigital Media10024.98.54.89
42Cameronirishfire777@gmail.comDigital Media10024.98.54.89
51Fahd Quadrifquadri@ggc.eduDigital Media100172.56.4.213
73Dudewho@gmail.comDigital Media100168.28.22.34
88sdfjgdfg@gfdg.comDigital Media1004.15.179.163
90sdfjgdfg@gfdg.comDigital Media1004.15.179.163
91sdfjgdfg@gfdg.comDigital Media1004.15.179.163
92sdflokinkl@fff.comDigital Media1004.15.179.163
94sdflokinkl@fff.comDigital Media10050.167.67.245
95sdflokinkl@fff.comDigital Media10050.167.67.245
96Bria Riversbrivers@ggc.eduDigital Media10024.125.233.10
97sdflokinkl@fff.comDigital Media10050.167.67.245
99Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
100Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
101Jack Cantrelljcantr13@gmail.comDigital Media10050.160.207.11
102Jack Cantrelladhk@gmail.comDigital Media10050.160.207.11
103jackjcantr13@gmail.comDigital Media10050.160.207.11
107dfgdfghj@ghj.comDigital Media100168.28.16.100
109sdflokinkl@fff.comDigital Media100168.28.2.98
111Dudewho@gmail.comDigital Media100168.28.22.34
112Dudewho@gmail.comDigital Media100168.28.22.34
119sdflokinkl@fff.comDigital Media10050.167.67.245
120sdflokinkl@fff.comDigital Media10050.167.67.245
121sdflokinkl@fff.comDigital Media10050.167.67.245
128Miguellol@hotmail.comDigital Media100168.28.22.96
131Fakelcopas@ggc.eduDigital Media100168.28.22.58
137Gloria Alvarengagalvaren@ggc.eduDigital Media100168.28.22.49
161dsfadfawe@fsdv.edaDigital Media10073.207.104.73
184Jim Coburnjimrcoburn@gmail.comDigital Media100168.28.22.32
185dwddwd@ggc.eduDigital Media100168.28.22.32
189Jim Coburnjimrcoburn@gmail.comDigital Media100168.28.22.32
There are totally 39 students in the Digital Media major with 100 points

Find all students of software major and having 0 points:
# Name Email Major Grade IP
14asdfasdf@ggc.eduSoftware050.147.203.70
75testtest@test.comSoftware01.22.88.169
76testtest@test.comSoftware01.22.88.169
84dfgdfdfgdfg@dgd.comSoftware024.159.127.238
There are totally 4 students in the Software major with 0 points

Major # of students Bar Percentage
Digital Media14674.87%
Security115.64%
Software2512.82%
Business84.1%
Other42.05%