Detect Applicant - Paid more with less Priority Chosen

[ErSKS]

Detec Applicant - Paid more but less priority selected than they can chose.

[ErSKS]

Paid NRs. 300 but less priority chosen

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 amount_paid=300 AND (dept_id_p2 = NULL OR dept_id_p2=99 OR dept_id_p3=NULL OR dept_id_p3=99)

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
5814	2684	42	4628	Suresh		Thapa	23	Batase	300	1	2	99
6084	3378	59.214	1105	Basant	Babu	Bhandari	73	parshuram	300	3	99	99
6227	4042	52.286	2126	Ishor		Aryal	35	Narayani	300	3	99	99
6538	10259	52.857	2060	Pujan		Budhathoki	4	Damak Municipality	300	1	3	99
6573	2127	58.071	1252	Deepak	Raj	Pant	72	bheemdatta	300	3	99	99

[ErSKS]

Paid NRs. 250 but chosen only one priority

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 amount_paid=250 AND (dept_id_p2 = NULL OR dept_id_p2=99)

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
5492	3269	50.5	2464	Mahesh		Pandey	49	butwal	250	3	99	99
5925	2271	57.571	1329	Srijan		Chaudhary	35	Ratnanagar	250	3	99	99
6042	4600	52.857	2054	Zeshika		Sharma	27	Tarkeshwor	250	1	99	99
6043	751	49.357	2756	Adhikari		Bibek	37	Bharte	250	1	99	99
6094	8283	47.357	3254	ISHAN		SHARMA	27	KATMANDU	250	3	99	99
6326	8979	63.143	733	Ambika		Dawadi	37	Bichour-1, Lamjung	250	3	99	99