Created
November 17, 2013 20:50
-
-
Save nelk/7518107 to your computer and use it in GitHub Desktop.
Shale's Query 1
select enr.sno, count(1) from enrollment as enr group by enr.sno;
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
12345678 1 | |
84018846 6 | |
84019017 6 | |
84022624 6 | |
85034647 7 | |
85342165 6 | |
85342166 3 | |
86008450 6 | |
86008529 6 | |
86008580 6 | |
86009653 6 | |
86009989 7 | |
86011956 6 | |
86017760 6 | |
86019292 6 | |
86025055 6 | |
86025140 6 | |
86027506 6 | |
86029696 6 | |
86034309 7 | |
86034935 6 | |
86037097 6 | |
86037205 6 | |
86040712 6 | |
86041426 6 | |
86052750 6 | |
86058592 6 | |
86059295 6 | |
86060194 6 | |
86060195 7 | |
86062791 6 | |
86064600 6 | |
86074211 6 | |
86076062 6 | |
86081917 6 | |
86084220 6 | |
86084610 6 | |
86085490 7 | |
86085491 6 | |
86085803 7 | |
86086979 6 | |
86089479 7 | |
86257905 6 | |
86260634 6 | |
86260654 6 | |
86312212 6 | |
86318504 6 | |
87001293 7 | |
87001758 7 | |
87001934 7 | |
87002563 7 | |
87002644 7 | |
87005079 7 | |
87006626 7 | |
87010055 7 | |
87010315 7 | |
87021004 6 | |
87021374 7 | |
87022181 7 | |
87023531 7 | |
87024423 7 | |
87024434 7 | |
87025170 6 | |
87026094 7 | |
87028233 6 | |
87028234 6 | |
87030936 6 | |
87033638 6 | |
87033639 6 | |
87034844 7 | |
87040981 7 | |
87041259 7 | |
87044283 6 | |
87045811 7 | |
87048032 7 | |
87049375 6 | |
87049376 6 | |
87055518 7 | |
87060195 7 | |
87060786 7 | |
87061242 6 | |
87061447 6 | |
87065014 6 | |
87066439 6 | |
87069506 7 | |
87070322 7 | |
87070468 7 | |
87070985 7 | |
87070997 7 | |
87071344 1 | |
87072404 1 | |
87072414 1 | |
87072464 3 | |
87074042 7 | |
87074091 7 | |
87076645 7 | |
87079587 7 | |
87081037 7 | |
87082608 7 | |
87085034 7 | |
87085772 6 | |
87088016 5 | |
87088017 6 | |
87088018 1 | |
87096136 7 | |
87097587 6 | |
87098339 7 | |
87098664 6 | |
87098675 6 | |
87099334 7 | |
87100535 7 | |
87100721 6 | |
87101385 7 | |
87254893 7 | |
87263357 7 | |
87263367 7 | |
87282127 7 | |
87352902 6 | |
87367140 6 | |
87367240 2 | |
87367241 1 | |
87367246 3 | |
87395859 6 | |
87396294 7 | |
88000768 7 | |
88000831 7 | |
88000917 6 | |
88000918 6 | |
88004937 7 | |
88006942 7 | |
88006959 6 | |
88006960 6 | |
88007364 6 | |
88007365 6 | |
88008141 6 | |
88008142 6 | |
88008698 7 | |
88008932 6 | |
88009115 7 | |
88015443 6 | |
88015444 6 | |
88016794 6 | |
88016795 6 | |
88017616 6 | |
88017617 6 | |
88018060 6 | |
88018061 6 | |
88019049 7 | |
88019159 6 | |
88026551 6 | |
88027110 7 | |
88028771 6 | |
88028772 6 | |
88029022 6 | |
88029023 6 | |
88029737 6 | |
88029738 6 | |
88031339 7 | |
88032631 6 | |
88032713 6 | |
88032714 6 | |
88033408 6 | |
88033920 7 | |
88034096 7 | |
88034234 6 | |
88034235 6 | |
88034659 7 | |
88034672 6 | |
88034673 6 | |
88034947 7 | |
88036707 6 | |
88036708 6 | |
88037863 6 | |
88038263 6 | |
88038264 6 | |
88038738 7 | |
88038770 7 | |
88038942 7 | |
88042794 6 | |
88042795 6 | |
88044308 7 | |
88045339 6 | |
88045340 6 | |
88045346 6 | |
88045347 6 | |
88045778 6 | |
88045779 6 | |
88046525 6 | |
88046526 6 | |
88047388 7 | |
88048885 7 | |
88048907 7 | |
88048944 7 | |
88049638 6 | |
88049639 6 | |
88051511 7 | |
88053601 6 | |
88054427 7 | |
88054682 6 | |
88055616 7 | |
88056530 7 | |
88057215 6 | |
88057216 6 | |
88057576 7 | |
88064435 6 | |
88065515 6 | |
88066388 6 | |
88066389 6 | |
88067304 7 | |
88067870 6 | |
88067871 6 | |
88070215 7 | |
88070248 6 | |
88072790 7 | |
88075793 7 | |
88076343 6 | |
88076344 6 | |
88076456 6 | |
88076457 6 | |
88080945 6 | |
88082861 6 | |
88083259 6 | |
88083260 6 | |
88084032 6 | |
88085489 6 | |
88085641 6 | |
88085642 6 | |
88086005 6 | |
88086055 7 | |
88086112 7 | |
88094964 7 | |
88095231 7 | |
88095431 6 | |
88096127 7 | |
88096128 6 | |
88096129 6 | |
88098096 6 | |
88098097 6 | |
88098195 7 | |
88099947 7 | |
88101551 6 | |
88101552 6 | |
88103060 6 | |
88103061 6 | |
88103370 6 | |
88103371 6 | |
88105650 6 | |
88105651 6 | |
88105720 6 | |
88105721 6 | |
88110070 7 | |
88111116 7 | |
88113144 6 | |
88113145 6 | |
88113267 7 | |
88208464 6 | |
88208617 7 | |
88214784 7 | |
88232655 7 | |
88235804 7 | |
88235857 7 | |
88235869 6 | |
88235870 6 | |
88238651 7 | |
88241206 6 | |
88270586 7 | |
88325065 6 | |
88325066 6 | |
88334283 6 | |
88334284 6 | |
88355069 7 | |
88375035 6 | |
89005387 6 | |
89007333 6 | |
89007334 6 | |
89010304 6 | |
89010305 6 | |
89010826 5 | |
89010827 6 | |
89010828 1 | |
89011045 6 | |
89011046 6 | |
89014659 6 | |
89014660 6 | |
89014997 6 | |
89014998 6 | |
89016333 7 | |
89016699 6 | |
89017608 6 | |
89020120 7 | |
89020128 6 | |
89020129 6 | |
89024469 7 | |
89025342 5 | |
89025343 6 | |
89025344 1 | |
89030392 6 | |
89030393 6 | |
89030404 6 | |
89030406 6 | |
89034244 6 | |
89034245 6 | |
89037674 6 | |
89038897 6 | |
89038916 6 | |
89039190 7 | |
89039504 7 | |
89040998 6 | |
89040999 6 | |
89041009 7 | |
89041228 7 | |
89043250 6 | |
89043251 6 | |
89046708 6 | |
89046709 6 | |
89047536 6 | |
89047537 6 | |
89047848 6 | |
89047849 6 | |
89048187 6 | |
89048253 6 | |
89048336 6 | |
89048578 6 | |
89050210 6 | |
89050211 6 | |
89052259 6 | |
89052260 6 | |
89052883 7 | |
89068857 6 | |
89068858 6 | |
89070546 7 | |
89070547 7 | |
89071418 6 | |
89071419 6 | |
89074993 6 | |
89074994 6 | |
89075019 6 | |
89075020 6 | |
89075036 6 | |
89075037 6 | |
89079248 7 | |
89081723 6 | |
89081724 6 | |
89082633 5 | |
89082634 6 | |
89082635 1 | |
89084792 6 | |
89084793 6 | |
89085245 5 | |
89085246 6 | |
89085247 1 | |
89089165 6 | |
89089166 6 | |
89089383 6 | |
89089384 6 | |
89091515 6 | |
89091516 6 | |
89092844 6 | |
89092845 6 | |
89094228 7 | |
89095171 6 | |
89095172 6 | |
89095539 6 | |
89095540 6 | |
89095776 6 | |
89095777 6 | |
89095998 6 | |
89095999 6 | |
89099135 7 | |
89113639 6 | |
89113640 6 | |
89114034 6 | |
89115047 6 | |
89120029 6 | |
89120030 6 | |
89219899 7 | |
89244686 6 | |
89258581 7 | |
89258593 6 | |
89258594 6 | |
89260975 6 | |
89297749 6 | |
89297750 6 | |
89411479 6 | |
89421220 6 | |
89427372 6 | |
89800306 7 | |
89800796 7 | |
90008424 6 | |
90008425 6 | |
90030393 6 | |
90030394 6 | |
90034236 6 | |
90034237 6 | |
90034243 6 | |
90034244 6 | |
90034245 6 | |
90034265 6 | |
90034308 6 | |
90041146 6 | |
90053052 6 | |
90053053 6 | |
90070304 6 | |
90070305 6 | |
90084540 6 | |
90084541 6 | |
90091662 6 | |
90091663 6 | |
90098260 6 | |
90098261 6 | |
90114818 6 | |
90119422 6 | |
90119423 6 | |
90162829 6 | |
90167289 7 | |
90206732 6 | |
90265195 7 | |
90355418 6 | |
90355419 6 | |
90355445 6 | |
90410351 6 | |
90410352 6 | |
90800271 7 | |
90994044 6 | |
90994048 6 | |
90994049 6 | |
90994062 6 | |
91088329 6 | |
91088330 6 | |
91800285 6 | |
91800324 7 | |
91800380 7 | |
91800931 7 | |
91990386 7 | |
91990388 7 | |
91990389 7 | |
91990391 7 | |
92800896 6 | |
92990154 6 | |
92990155 6 | |
92990156 6 | |
92990157 6 | |
92990159 6 | |
92990365 6 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment