Popullimi (shfrytezuesi)

insert into ShfrytezuesiTeDhenatPersonale(shID,Emri,Mbiemri,DataeLindjes,Gjinia,StatusiMartesor)
values
('SH001','Anita','Hoxha','1968-7-8','F','Beqare'),
('SH002','Albert','Sinani','1971-9-7','F','I Martuar'),
('SH003','Diellza','Aliu','1974-3-25','F','Beqare'),
('SH004','Steve','Freeman','1974-11-20','F','I Fejuar'),
('SH005','Kevin','Woods','1976-6-21','F','Beqar'),
('SH006','Alice','Johnson','1979-5-28','F','E Martuar'),
('SH007','Santiago','Agua','1993-6-25','F','Beqar'),
('SH008','Julian','Bachmeier','1983-2-14','F','Beqar'),
('SH009','Gilberta','Kaufman','1986-1-3','F','E Fejuar'),
('SH010','Tiara','Drejta','1982-4-10','F','E Martuar');
insert into shfrytezuesikontakti(shID,NrMob,NrFix,Email)
values
('SH001','+37744192582','N/A','anitahoxha@gmail.com'),
('SH002','+38649106222','+38638192510','asinani@outlook.com'),
('SH003','+37745152055','N/A','aliu.diellza@gmail.com'),
('SH004','+443069990194','N/A','stevef@hotmail.com'),
('SH005','+441174960442','N/A','woods712@live.com'),
('SH006','+12025550125','+1207296023','alicej1979@gmail.com'),
('SH007','+934124602','+935124701','santiagogoagua@yahoo.com'),
('SH008','+1541753010','N/A','julianbach@gmbh.de'),
('SH009','+15411263739','+15491293043','kaufmang@hotmail.com'),
('SH010','+38643629930','N/A','tiara.drejta@yahoo.com');
insert into shfrytezuesiprofili(shID,EmriiPerdoruesit,Fjalekalimi,Gjuha,FotoProfilit)
values
('SH001','anita.hoxha','RerwmQJW','Shqip','tinyurl.com/profilepic001'),
('SH002','asinani','swkd7SSk','Shqip','tinyurl.com/profilepic002'),
('SH003','diellza_aliu','ZuGszzVa','Shqip','tinyurl.com/profilepic003'),
('SH004','steve361f','XnPkK2pb','Anglisht','tinyurl.com/profilepic004'),
('SH005','kevinwoods','6xenajzn','Anglisht','tinyurl.com/profilepic005'),
('SH006','alice.j','rfRmZjn9','Anglisht','tinyurl.com/profilepic006'),
('SH007','santiagoagua9','5542E7RV','Spanjolle','tinyurl.com/profilepic007'),
('SH008','julian.ge','YJxpfA53','Gjermane','tinyurl.com/profilepic008'),
('SH009','gilbertakauf','5MeJ8HsH','Gjermane','tinyurl.com/profilepic009'),
('SH010','tiara.drejta','MDvhDP9K','Shqip','tinyurl.com/profilepic010');
insert into ShfrytezuesiAdresaDheInstituti(shID,Rruga,Qyteti,Shteti,KodiPostal,Institucioni,Departamenti,EmailiInstitucionit)
values
('SH001','Gazmend Zajmi','Prishtine','Kosove','10000','Universiteti i Prishtines','Shkenca Politike','anita.hoxha@uni-pr.edu'),
('SH002','Agim Ramadani','Prishtine','Kosove','10000','Universiteti i Prishtines','Inxhinieri Kompjuterike','albert.sinani@uni-pr.edu'),
('SH003','Adem Jashari','Mitrovice','Kosove','40000','Universiteti i Mitrovices','Menaxhment dhe Informatike','diellza.aliu@uni-mi.edu'),
('SH004','29 Southern Way','North Elham','Angli','NR20 9UZ','Kolegji Seaford','Kriminalistike','steve.freeman@kol-se.edu'),
('SH005','16 Essex Rd','Londer','Angli','LL48 4DD','Universiteti i Londres','Shkenca Matematikore','kevin.woods@uni-lo.edu'),
('SH006','3 Hudson St','Dunsby','Angli','PE10 9ER','Universiteti i Kingstonit','Biologjise Humane','alice.johnson@uni-ki.edu'),
('SH007','Padre Laro 85','Madrid','Spanje','13591','Universiteti i Madridit','Konstruktiv','santiago.agua@uni-ma.edu'),
('SH008','Leipziger Straße 32','Frankfurt','Gjermani','34359','Universiteti i Vienes','Kimi Inxhinierike','julian.bachmeier@uni-vi.edu'),
('SH009','Potsdamer Platz 82','Berlin','Gjermani','88169','Universiteti i Frankfurtit','Teknologji Ushqimore','gilberta.kaufman@uni-fr.edu'),
('SH0010','Letališka 54','Ljubljana','Slloveni','2259','Universiteti i Ljubljanes','Dizajn Grafik','tiara.drejta@uni-lj.edu');
insert into ShfrytezuesiMiqesia(shID,Followers,Following)
values
('SH001','3679','820'),
('SH002','1394','890'),
('SH003','519','639'),
('SH004','302','281'),
('SH005','10439','1235'),
('SH006','371','305'),
('SH007','150','103'),
('SH008','4762','723'),
('SH009','203','201'),
('SH0010','600','307');
insert into ShfrytezuesiEdukimi(shID,Bachelor,Msc,Phd)
values
('SH001','1','1','1'),
('SH002','1','1','0'),
('SH003','1','1','0'),
('SH004','1','1','0'),
('SH005','1','1','1'),
('SH006','1','0','0'),
('SH007','1','1','0'),
('SH008','1','1','1'),
('SH009','1','0','0'),
('SH0010','1','1','0');
insert into ShfrytezuesiPunaAktuale(shID,PunaAktuale)
values
('SH001','Profesoreshe dhe Politikane'),
('SH002','IT'),
('SH003','N/A'),
('SH004','Mjekesi Ligjore'),
('SH005','Profesor'),
('SH006','N/A'),
('SH007','Asistent'),
('SH008','Kimist'),
('SH009','N/A'),
('SH0010','Dizajnere Grafike');
insert into ShfrytezuesiPunaeMeparshme(shID,PunaeMeparshme)
values
('SH001','Asistente'),
('SH001','Keshilltare'),
('SH002','Asistent'),
('SH003','Asistente'),
('SH004','Detektiv'),
('SH005','Asistent'),
('SH005','Kontabilist'),
('SH006','Arsimtare'),
('SH007','N/A'),
('SH008','Profesor'),
('SH009','N/A'),
('SH0010','Asistente'),
('SH0010','Zhvilluese e Web-it');
insert into ShfrytezuesiAftesiteProfesionale(shID,AftesiaProfesionale,PervojaePunes)
values
('SH001','Politikat ekonomike','7'),
('SH001','Politikat financiare','13'),
('SH002','Zhvillimi i lojerave','8'),
('SH003','Menaxhim i Projekteve Softuerike','6'),
('SH004','Detektiv i vrasjeve','8'),
('SH004','Mjekesi ligjore kriminalistike','10'),
('SH005','N/A','0'),
('SH006','Sjellet e kafsheve shtepiake','6'),
('SH007','Ndertim i shtepive','12'),
('SH007','Konstruktim i peshave te renda','5'),
('SH008','Reaksione Laboratorike','11'),
('SH009','N/A','0'),
('SH0010','Zhvilluese e Web-it','7');
insert into ShfrytezuesiInteresimi(shID,FushaeInteresimit)
values
('SH001','Politike'),
('SH002','Ndermarresi'),
('SH002','Shkenca dhe teknologjia'),
('SH003','Zhvillimi i te rinjeve'),
('SH004','Politika e armeve'),
('SH005','Zhvillimi i shkences'),
('SH005','Mikrofinance'),
('SH006','Mjedisi'),
('SH007','Pune publike'),
('SH008','Te drejtat e njeriut'),
('SH008','Edukim'),
('SH009','Agronomi'),
('SH0010','Teknologji');
insert into ShfrytezuesiStatistikaDyMuajteFundit(shID,NrLeximeve,NrShkarkimeve,NrCitimeve)
values
('SH001','21','3','3'),
('SH002','35','6','2'),
('SH003','17','2','0'),
('SH004','58','9','6'),
('SH005','203','21','37'),
('SH006','35','5','1'),
('SH007','44','6','10'),
('SH008','12','0','2'),
('SH009','39','7','9'),
('SH0010','52','9','4');