search

ErSKS / KhCE

Khwopa College of Engineering
5 stars 0 forks source link

Auto-check - isCorrectInformation() in R/D Quota? #90

Closed ErSKS closed 7 years ago

ErSKS commented 7 years ago

Develop a SQL to auto check applicant of N/D Quota is valid or not?

ErSKS commented 7 years ago

Nagar Quota List

SELECT id, entrance_roll, entrance_score, entrance_rank, firstName, middleName, lastName, district_id, pAdd_muncVDC, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3 FROM student_apply WHERE verified=1 AND quota="Bhaktapur Municipality";

id entrance_roll entrance_score entrance_rank firstName middleName lastName district_id pAdd_muncVDC amount_paid dept_id_p1 dept_id_p2 dept_id_p3
5028 6702 41 5039 Sonik   Kuluju 26 Bhaktapur Municipality 200 1 99 99
5035 4925 39.5 5382 Abhishek   Wagle 26 madhyapur thimi 250 1 2 99
5041 10 53.643 1873 Prashun   Chitrakar 26 Bhaktapur 200 3 99 99
5051 4754 57.643 1283 Nirmala   Kutuwo 26 Bhaktapur municipality 300 3 1 2
5067 2531 38.214 5825 Rikeb   Shilpakar 26 Bhaktapur Municpality 200 1 99 99
5072 4185 47.357 3200 Bibek   Shyama 26 Bhaktapur 250 3 1 99
5087 887 57.124 1963 Nirajan   Prajapati 26 bhaktapur 200 3 99 1
5094 8360 48.143 3015 Shree Krishna Tuitui 26 bhaktapur 250 3 1 99
5112 5713 58.643 1165 Radil   Twayana 26 Bhaktapur 200 1 99 99
5126 7733 41.357 4846 Sujit   Bhuju 26 Bhaktapur Municipality 200 1 99 99
5143 9711 54.429 1761 Aayush   Pradhananga 26 Bhaktapur 250 1 3 99
5154 5013 60.714 940 Sujan   Prajapati 26 Bhaktapur 250 1 3 99
5162 2863 57.571 1357 Seron   Amatya 26 Bhaktapur 200 1 99 99
5166 8816 45.786 3679 Aniket   Manandhar 26 bhaktapur 300 2 1 3
5168 220 52.571 2107 Nemika   Sachin 26 Bhaktapur 200 1 99 99
5177 2374 60.786 927 Bibek   Gosai 26 Bhaktapur 250 1 2 99
5180 8439 47.357 3201 Ratish   Nyaichyai 26 bhaktapur 250 3 1 99
5189 1586 42.143 4598 Shradha   Bhuju 26 bhaktapur municipality 200 3 1 1
5193 5119 41.857 4669 Deepjyoti Disti 26 Bhaktapur 200 1 99 99
5195 8055 43.429 4326 Ujan   Shakya 26 Bhaktapur Municipality 200 3 99 99
5221 8607 44.786 3924 Radiate   Kisi 26 bhaktapur 250 3 1 99
5225 4348 42.643 4489 Aayusha   Bhataju 26 Bhaktapur 200 1 99 99
5226 7639 38.857 5562 Aakash   Khaiju 26 Bhaktapur 200 1 99 99
5229 8359 39.5 5425 Rajeev   Chhusyabaga 26 bhaktapur 250 1 3 99
5236 2841 58.357 1236 Sanam   Shrestha 26 Bhaktapur 200 1 99 99
5244 8571 35.571 6853 Sahas   Khaitu 26 bhaktapur 300 1 3 2
5266 8463 35.714 6645 Pranish   Suwal 26 bhaktapur municipality 250 1 3 99
5275 5683 45 3883 Srijan   Phaiju 26 Bhaktapur 250 1 3 99
5278 2324 42.643 4421 Suraj   Duwal 26 Bhaktapur 250 1 2 99
5281 8536 59.143 1132 Suraj   Gosai 26 bhaktapur 200 3 99 99
5284 3340 63.857 680 Nischal   Prajapati 26 Bhaktapur municipality 200 1 99 99
5294 2397 45.857 3552 Sajan   Tulsibakhyo 26 Bhaktapur 250 1 2 99
5304 2999 58.357 1191 Bikesh   Khatri 26 Bhaktapur 250 1 3 99
5309 1289 45 3770 Bikesh   Sitikhu 26 Bhaktapur Municipality 250 3 1 99
5311 6003 43.357 4348 Kopila   Gainju 26 Bhaktapur 200 1 99 99
5337 4546 61.071 913 Anuj   Ghimire 26 Bhaktapur 200 1 99 99
5349 89 45.786 3650 Aman   Mool 26 Bhaktapur 200 3 99 99
5353 6882 47.357 3289 Royal Raj Tuitui 26 Bhaktapur Municipality 300 1 3 2
5354 4179 56.786 1467 Sneha   Bajracharya 26 Bhaktapur Municipality 200 1 99 99
5355 3750 39.357 5509 Jumir   Gosain 26 Bhaktapur Municipality 250 3 1 99
5366 4947 43 4152 Sofiya   Prajapati 26 Bhaktapur 250 3 1 99
5370 8052 40.286 5209 Denish   Machamasi 26 Bhaktapur 300 1 3 2
5372 8061 45 3859 Bikram   Sainju 26 Bhaktapur 300 1 2 3
5377 1366 53.643 1920 Sunil   Maka 26 Bhaktapur Municipality 200 2 99 99
5381 3172 37.143 6288 Prajan   Sayanju 26 Bhaktapur 250 1 3 99
5383 6503 44 4044 Shreejana Khoteja 26 Bhaktapur municipality 200 1 99 99
5386 4985 45 3819 Oshin   Gansi 26 Bhaktapur 250 3 2 99
5392 8058 38.714 5667 Nilam   Jareju 26 bhaktapur municipality 300 1 2 3
5407 8699 49.143 2773 Siddhant   Prajapati 26 Bhaktapur 200 1 99 99
5410 7720 36.357 6572 Welish   Byanju 26 Bhaktapur Municipality 200 1 99 99
5411 6172 45 3853 Anish   Manandhar 26 Bhaktapur 250 1 2 99
5412 3207 37.929 6016 Anish   Awal 26 Bhaktapur 300 1 2 3
5440 3517 40.429 5090 Sanam   Madhikarmi 26 Bhaktapur Municipality 300 1 99 1
5451 4655 40.286 5113 Babin   Datheputhe 26 Bhaktapur Municipality 200 3 99 99
5476 1959 43.429 4293 Rukesh   Rajbhandari 26 Bhaktapur Municipality-6 200 1 99 99
5481 1602 43.643 4180 Sujata   Suwal 26 Bhaktapur municipality 200 3 99 99
5504 4 43.143 4362 Lucky Sington Shrestha 26 Bhaktapur Municipality 200 3 99 99
5533 2588 54.643 1730 Rajan   Suwal 26 Bhaktapur Municipality 250 1 3 99
5573 3914 67 466 Nisan   Twayana 26 Bhaktapur 200 1 99 99
5577 5991 52.857 2011 Sanjay   Tukanbanjar 26 Bhaktapur municipality 250 1 3 99
5582 7663 35.14 6918 Bijen   Suwal 26 Bhaktapur 200 1 99 99
5583 2842 52.071 2199 Babban Ram Hada 26 Bhaktapur Municipality 200 1 99 99
5585 7751 51.714 2272 Shreejsn   Kisee 26 Bhaktapur 250 3 1 99
5586 10194 50.5 2526 Nikesh   Suwal 26 Bhaktapur 200 1 99 99
5604 2949 49.357 2759 Anusha   Bajracharya 26 Bhaktapur 200 3 99 1
5606 8035 35.571 6764 Mangita   Sanda 26 Bhaktapur 200 1 99 99
5634 4968 41.857 4769 Niraj   Shilpakar 26 Bhaktapur 200 2 99 99
5647 391 48.143 3093 Rajen   Hachhethu 26 bhaktapur municipality-12 200 1 99 99
5652 9707 45.857 3561 Suraj   Gwachha 26 Bhaktapur Municipality 250 1 2 99
5653 404 63.071 757 Prajwol   Pakka 26 Bhaktapur 200 2 99 99
5671 5025 36.357 6476 Niran   Gorkhali 26 bhaktapur 300 1 3 2
5679 5978 36.357 6425 Anusha   Bati 26 Bhaktapur Municipality 250 1 2 99
5693 6878 42.643 4407 Sujil   Tuitui 26 Bhaktapur 300 1 2 3
5770 9285 44.643 3935 ANISH   KHAYARGOLI 26 Bhaktapur 200 1 3 2
5776 7513 41.071 5036 Aelen   Prajapati 26 Bhaktapur muncipality 200 1 99 99
5787 3296 49.714 2743 Luja   Shakya 26 Bhaktapur 250 3 2 99
5793 2898 45.786 3632 Nimesh   Chhukan 26 Bhaktapur municipality 200 3 99 99
5794 3059 67.786 411 Niranjan   Bekoju 26 Bhaktapur Municipality 200 3 99 99
5808 8336 46.571 3441 Rojish   Prajapati 26 Bhaktapur municipality 200 1 99 99
5929 7302 48.929 2931 Nirjal   Prajapati 26 Bhaktapur Municipality 200 3 99 99
5986 7838 37.143 6205 Arun   Prajapati 26 Bhaktapur Municipality 200 3 99 99
5999 2860 57 1382 Nabin   Libi 26 bhaktapur 200 2 99 99
6049 2783 36.5 6370 Rajan   Prajapati 26 Bhaktapur 250 1 3 99
6063 6993 39.5 5443 Ramesh   Dhingri 26 Bhaktapur Municipality 200 1 99 99
6088 6471 35.071 6924 Kriti   Sujakhu 26 Bhaktapur Municipality 200 1 99 99
6098 7058 37.929 5904 Bikal   Gosai 26 Bhaktapur Municipality 200 1 99 99
6099 7077 39.5 5445 Manisha   Gora 26 bhaktapur 250 3 1 99
6136 655 42.786 4389 Bikram   Baidhya 26 Bhaktapur municipality 250 1 2 99
6137 7555 38.429 5811 Sanjeev   Sainju 26 Bhaktapur 200 1 99 99
6146 10318 41.857 4774 Kushal   Suwal 26 bhaktapur 250 1 3 99
6155 11528 59.929 1075 Anish   Prajapati 26 Bhaktapur 300 1 3 2
6164 5967 41.071 4959 Sangya   Tulsi 26 Bhaktapur Municipality 250 1 2 99
6208 3435 39.5 5411 Bikram   Twayana 26 Suryabinayak 200 3 NULL NULL
6223 11669 56.714 1476 Sushil   Dyopala 26 Bhaktapur municipality 200 3 99 99
6273 8602 53.286 1961 Amit   Duwal 26 Bhaktapur Municipality 300 1 3 2
6596 9512 49.714 2660 Ankit   Raya 26 Bhaktapur Municipality 300 3 1 2
ErSKS commented 7 years ago

District Quota List

SELECT id, entrance_roll, entrance_score, entrance_rank, firstName, middleName, lastName, district_id, pAdd_muncVDC, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3 FROM student_apply WHERE verified=1 AND quota="Bhaktapur District";

id entrance_roll entrance_score entrance_rank firstName middleName lastName district_id pAdd_muncVDC amount_paid dept_id_p1 dept_id_p2 dept_id_p3
3014 5552 53.786 1861 Sabin   Suwal 26 Changunarayan 250 3 1 99
5009 10206 47.357 3286 Sushim   Takhachhe 26 Suryabinayak 300 3 2 1
5018 2270 48.929 2851 Kshitij Dhanga Shrestha 26 madhyapur thimi 200 1 99 99
5052 3799 48.929 2900 Kokish Karan Bhusal 26 Madhyapur Thimi 200 1 99 99
5069 3129 41.857 4811 Adarsha   Mathema 26 Suryabinayak 300 3 1 2
5078 408 54.643 1729 Nilima   Jayana 26 Madhyapur Thimi 200 1 99 99
5084 213 41.071 4965 Nimesh Mani Risal 26 Suryabinayak Municipality 200 3 99 99
5086 2959 47.357 3270 Trishna   BalayaShrestha 26 Madhyapur Thimi 300 1 3 2
5104 2545 57.571 1334 Rohit   Prajapati 26 Madhyapur Thimi Municipal 250 3 1 99
5149 2285 48.929 2870 Rachana   Prajapati 26 Madhyapur, thimi 250 1 3 99
5153 7268 53 1985 Prabal   Khaiju 26 Changunarayan 200 1 99 99
5179 878 35.571 6718 Eshan   Dahal 26 Madhyapur Thimi 250 1 3 99
5201 4768 60.714 985 Sandip   Bata 26 Changunarayan 200 1 99 99
5202 8808 45.786 3567 Sujan   Prajapati 26 Madhyapur Thimi 250 1 3 99
5205 7916 37.143 6160 Sandesh   Khatri 26 changunarayan 250 1 3 99
5206 5687 58.357 1239 Sanskriti   Dhakal 26 changunarayan-2-Bhaktapur 200 1 99 99
5209 4195 49.714 2687 Kanchan   Budhathoki 26 Madhyapur, thimi 250 1 3 99
5210 2412 64.143 665 Suraj   Sulu 26 changunarayan 200 1 99 99
5252 7406 45.786 3668 Karuna   Phoju 26 Changunarayan 250 1 3 99
5255 4226 35.571 6791 Niroj   Shrestha 26 Madhyapur Thimi municipal 250 1 3 99
5263 4004 67 481 Puspa Raj Neupane 26 changunarayan 200 1 99 99
5264 5301 42.71 4405 Aashish   Dheke 26 Madhyapur Thimi 200 3 99 99
5272 5042 41.071 4955 Sushan   Prajapati 26 Madhyapur Thimi municipal 250 1 3 99
5299 7222 39.857 5273 Unisha   Kibachhe 26 Suryabinayak 250 1 3 99
5312 3303 61.643 852 Aakash   Basu 26 Suryabinayak 200 1 99 99
5315 1193 52.857 2073 Aashish   Timilsina 26 Suryabinayak municipality 200 1 99 99
5360 9798 54.857 1713 Ujjwol   Acharya 26 Anantalingeshwor 200 1 99 99
5401 4851 53.143 1971 Bishal   Basnet 26 Suryabinayak municipality 200 1 99 99
5417 2835 54.429 1769 Aastha   Thapa 26 Suryabinayak municipality 250 1 3 99
5424 9485 38.857 5565 Prabhat   Thapa 26 Suryabinayak municipality 250 2 3 99
5430 5072 55.214 1677 Aakriti   Aganja 26 Changunarayan 200 3 99 99
5459 6968 48.929 2915 Pratik   Neupane 26 Changunarayan Municipalit 250 1 2 99
5460 8505 55.214 1686 Rupa   Sahukhal 26 Madhyapurthimi 200 1 99 99
5480 4780 48.929 2911 Aashish   Shrestha 26 Madhyapur thimi 200 1 99 99
5496 4771 56 1569 Anup   Shrestha 26 Madhyapur thimi 200 1 99 99
5505 6725 42.929 4375 Samir   Dhungana 26 suryabinayak municipality 250 1 3 99
5509 8562 52.071 2235 Ram   Katwal 26 Suryabinayak 250 3 1 99
5520 5250 41.071 4995 Binika   Prajapati 26 madhyapur thimi 250 1 3 99
5539 10618 37.929 6024 Shrawan Kumar Bogati 26 Suryabinyak 250 1 3 99
5546 2162 36.929 6328 Saragam   Ghimire 26 Anantalingeshwor 200 3 99 99
5568 3261 54.429 1807 Sunil   Banmala 26 suryabinayak 250 3 1 99
5570 3321 48.929 2895 Sanita   Banmala 26 suryabinayak 250 1 3 99
5590 4112 50.5 2519 Yogendra   Duwal 26 changunarayan 300 1 2 3
5596 6984 45.786 3667 Biraj   Neupane 26 Changunarayan municipalit 250 1 3 99
5617 3885 44.5 3943 Subhechchha Dahal 26 changunarayan 300 1 3 2
5623 5038 35.571 6678 Rachana   Prajapati 26 madhyapur thimi 250 1 3 99
5633 4125 50.5 2521 Aarati   Thapa 26 Suryabinayak municipality 200 1 99 99
5636 3449 53.286 1959 Sampanna Bajracharya 21 Monthali 200 1 99 99
5638 5151 42.714 4403 Neha   Shrestha 26 madhyapur thimi 250 3 1 99
5641 10676 56.786 1456 Anish   Maharjan 27 Kirtipur 200 1 99 99
5662 5383 47.357 3253 Subin   Timilsina 26 Nagarkot-7, Bhaktapur 250 3 1 99
5692 11245 37.357 6086 Kanchan Joshi Sukubhattu 26 suryabinayak municipality 250 1 3 99
5705 11505 46.571 3465 Sushan   Shrestha 26 Madhyapur Thimi 250 1 3 99
5707 9699 40.286 5186 Shristi   Shrestha 26 madhyapur thimi 250 1 3 99
5727 5605 44.214 4080 Monika   Bakhunchhe 26 suryabinayak-5 bhaktapur 250 1 3 99
5761 3706 42.643 4455 Prajwol   Shrestha 26 Madhyapur Thimi 200 1 99 99
5769 4001 45 3794 Pratik   Shrestha 26 madhyapur thimi 200 3 99 99
5777 6873 46.929 3324 Suman   Shrestha 26 Changunarayan 250 3 2 99
5784 5855 48.571 2958 Sachit Kumar Shrestha 26 Nagarkot 250 1 3 99
5802 5162 51.286 2331 Rabina   Nayabhari 26 Suryabinayak 300 1 2 3
5820 9493 59.929 1070 Pratik   Thapa 26 Suryabinayak municipality 300 2 3 1
5825 12330 43.429 4321 Sharan   Shrestha 26 Suryabinayak Municipality 300 1 3 2
5841 9060 38.714 5748 Saroj   Silwal 26 Suryabinayak 250 3 1 99
5846 7544 38.714 5643 Sanjaya   Makaju 26 Changunarayan 200 1 99 99
5857 6925 47.357 3229 Aakash   Shrestha 26 Suryabinayak 250 3 1 99
5924 5890 51.143 2402 Sahas   Prajapati 26 Madhyapur Thimi 200 3 99 99
5931 8473 50.929 2413 Sayar   Prajapati 26 Madhyapur Thimi 300 1 2 3
5938 2967 62.286 829 Supriya   Sharma 26 Madhyapur Thimi 200 3 99 99
5956 5828 56 1577 Abhishek   Neupane 26 Suryabinayak municipality 200 3 99 99
5963 5767 37.143 6231 Yubik   Prajapati 26 Bhaktapur 250 1 3 99
5966 2059 45 3882 Sanju   Shrestha 26 Madhyapur Thimi 300 1 2 3
5970 11735 39.5 5329 Sijan   Joshi 26 Suryabinayak Municipality 300 3 1 2
5988 4251 58.357 1195 Prity   Dhungana 26 Changunarayan 200 1 99 99
6002 627 49.571 2746 Sayara   Bhujel 26 changunarayan 200 1 99 99
6037 6149 48.929 2914 Saksham   Bohara 26 anantalingeshwor 250 1 3 99
6066 7821 39.643 5306 Nilesh Jyo Shrestha 26 Madhyapur Thimi 300 1 2 3
6077 1030 53.64 1915 Swarnima Shrestha 26 suryabinayak municipality 200 1 99 99
6124 9834 54.429 1805 Raj Kumar Parajuli 26 Changunarayan 200 1 99 99
6220 11636 46.571 3411 Bibash   Rajthala 26 Suryabinayak Municipality 250 3 1 99
6230 8127 43.714 4168 Niraj   Ghimire 26 Suryabinayak Municipality 250 1 3 99
6316 6906 59.857 1079 Utsav   Neupane 26 suryabinayak municipality 250 1 3 99
6321 1799 36.357 6535 Smriti   Manandhar 26 Madhyapurthimi 200 3 99 99
6322 959 54.429 1778 Ilam   Shrestha 26 Madhyapur Thimi 200 3 99 99
6332 6723 49.714 2682 Aman   Shrestha 26 Anantalingeswor Municipal 200 3 99 99
6403 10324 45 3814 Dibash Kumar Khatri 26 Suryabinayak 250 2 1 99
6416 10189 38.714 5746 Rabin   Awal 26 Changunarayan 200 2 99 99
6428 10824 35.571 6800 Pratik   Thapa 26 Anantalingeshwor Municipa 300 1 3 2
6441 5113 36.643 6352 Reetu   Adhikari 26 Changunarayan 250 1 3 99
6457 11610 49.714 2735 Gaurab   Thapa 26 Changunarayan Municipalit 200 1 99 99
6463 2745 39.714 5293 Sushant   Thapa 26 madhyapur thimi 250 1 2 99
6549 12106 38.714 5683 Kriti   Prajapati 26 Madhyapur Thimi 200 3 99 99
ErSKS commented 7 years ago

District Detail & Quota Cross-check

SELECT id, entrance_roll, entrance_score, entrance_rank, firstName, middleName, lastName, district_id, pAdd_muncVDC, quota, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3 FROM student_apply WHERE verified=1 AND district_id=26 [District Detail & Quota Cross-check.zip]

(https://github.com/ErSKS/KhCE/files/1238594/District.Detail.Quota.Cross-check.zip)