TESTET - TRANSACT SQL -

Nr.	Emri dhe Mbiemri	Test - 1		Test - 2
1	Adnan Pirota	90	69	92.00
2	Armend Huskaj	87		0.00
3	Artan Studenica	81	13	17.33
4	Armend Gjoshi	80	62	82.67
5	Shqiprim Shala	77	58	77.33
6	Shkelqim Mekaj	62	49	65.33
7	Florin Broqi	60	25	33.33
8	Driton Domniku	50	5	6.67
9	Sabahate Goga	47	35	46.67
10	Agon Maraj	40		0.00
11	Meriton Berisha	35		0.00
12	Dardan Demhasaj	30	31	41.33
13	Sadik Shala	23		0.00
14	Labinot Lajqi	17	17	22.67
15	Valon Sapunxhiu		0	0.00

Baza testi i dyte

Bazat relacinale te te dhenave			Testi I dyte
Emri	Mbiemri	Poena	Perqindja
Milot	Hysenaj	59	78.67
Blerim	Nikqi	68	90.67
Lum	Vuthi	54	72.00
Vigan	Dranqolli	59	78.67
Dafina	Elezaj	60	80.00
Dardan	Elezaj	50	66.67
Arbnor	Studenica	63	84.00
Antian	Asllani	45	60.00
Blend	Haxhaj	64	85.33
Dardan	Gashi	58	77.33
Qendresa	Krasniqi	74	98.67
Burim	Bajraktari	68	90.67
Drilon	Krasniqi	60	80.00
Besart	Gjikolli	64	85.33
Besnik	Shabanaj	65	86.67
Valdet	Shabaj	65	86.67
Agron	Myftari	75	100.00
Sinan	Ramosaj	65	86.67
Veton	Pervorfi	62	82.67
Granit	Shala	65	86.67
Ermir	Imami	75	100.00
Agon	Fazlija	30	40.00