Notes

create table user_ (
u_id int primary key not null,
u_name varchar(255),
email varchar(255),
phone varchar(10),
age int,
IBAN varchar(24),
credit int
)
create table courts(
cid int primary key not null,
cname varchar(255),
csize varchar(1),
ctype varchar(20),
cprice int,
clocation varchar(255)
)
create table res (
u_id int ,
cid int ,
date_ Date,
time_ varchar(2),
foreign key (u_id) references user_ (u_id),
foreign key (cid) references courts (cid)
)

INSERT ALL
into user_ values (1,'yaser fisal','[email protected]','0583703684',20,'SA7826600910240420092254',503)
into user_ values (2,'amjad yaser','[email protected]','0583955100',16,'SA3384616273555837079901',128)
into user_ values (3,'jasim naif','[email protected]','0580869726',21,'SA8583441144362346256223',111)
into user_ values (4,'khalid mazen','[email protected]','0543832041',21,'SA0195476964528719045411',281)
into user_ values (5,'omar ibrahim','[email protected]','0582630216',15,'SA0026893499241264411233',459)
into user_ values (6,'mazen alaa','[email protected]','0553924771',25,'SA5644669221952141869316',498)
into user_ values (7,'anmar maher','[email protected]','0580344576',28,'SA2132224328897541811444',91)
into user_ values (8,'jssar majed','[email protected]','0537076627',21,'SA5144434340450613250707',213)
into user_ values (9,'amir jssar','[email protected]','0538947915',28,'SA0293104253888837211938',377)
into user_ values (10,'alaa turki','[email protected]','0564983228',15,'SA9871250894388943325589',113)
into user_ values (11,'yaser ibrahim','[email protected]','0534076743',27,'SA3606358457868732051233',423)
into user_ values (12,'mazen ziyad','[email protected]','0569795025',30,'SA6135570912695283507275',253)
into user_ values (13,'turki anmar','[email protected]','0555358470',25,'SA4283784763253807064325',472)
into user_ values (14,'alaa turki','[email protected]','0586243029',27,'SA5724583883879282814096',194)
into user_ values (15,'malek muhamad','[email protected]','0535256011',28,'SA1280242817014934970055',36)
into user_ values (16,'turki khalid','[email protected]','0559766277',26,'SA9848655916556154935931',318)
into user_ values (17,'hasan amir','[email protected]','0588831558',26,'SA8662545480457818918102',449)
into user_ values (18,'mazen turki','[email protected]','0535009823',27,'SA2084089482728830441109',507)
into user_ values (19,'alaa ahmad','[email protected]','0548955492',22,'SA1884348153480979734000',241)
into user_ values (20,'ali hasan','[email protected]','0565459212',24,'SA2001438684191464151902',486)
into user_ values (21,'majed jasim','[email protected]','0559684161',18,'SA2027961561686739437726',403)
into user_ values (22,'ziyad ahmad','[email protected]','0551309611',24,'SA4801935590960756520916',271)
into user_ values (23,'hashim mazen','[email protected]','0553788531',29,'SA6041788338007922828579',218)
into user_ values (24,'amjad alaa','[email protected]','0554938500',18,'SA0029060205952313290042',438)
into user_ values (25,'hasan ziyad','[email protected]','0559384389',23,'SA9046759021019576629979',444)
into user_ values (26,'yazeed ammar','[email protected]','0535051980',29,'SA9078446264286209894999',141)
into user_ values (27,'anmar ahmad','[email protected]','0547097672',31,'SA6941407937033314451584',127)
into user_ values (28,'omar saleh','[email protected]','0548838967',20,'SA0479583894048829488350',241)
into user_ values (29,'ammar jasim','[email protected]','0565520591',17,'SA6327722522641346492888',84)
into user_ values (30,'khalid ahmad','[email protected]','0569401805',30,'SA1262266068829739816200',377)
into user_ values (31,'anmar ahmad','[email protected]','0551699002',18,'SA1842307639398700747965',316)
into user_ values (32,'hasan saud','[email protected]','0561455479',20,'SA1417569668365849087682',154)
into user_ values (33,'jssar amjad','[email protected]','0550141816',17,'SA6222216722798247741538',457)
into user_ values (34,'hasan hasan','[email protected]','0550465656',17,'SA1241627355894286405696',474)
into user_ values (35,'yaser saleh','[email protected]','0586196696',24,'SA4504798184520627536393',268)
into user_ values (36,'ziyad turki','[email protected]','0536394268',29,'SA9509967129853013952373',409)
into user_ values (37,'yaser mazen','[email protected]','0567199451',16,'SA9700088435495062232551',203)
into user_ values (38,'majed saleh','[email protected]','0544065522',26,'SA6067780104118513110968',150)
into user_ values (39,'ziyad turki','[email protected]','0540738181',22,'SA6301854386477288651625',386)
into user_ values (40,'turki ali','[email protected]','0586121051',29,'SA5603647638019641734697',124)
into user_ values (41,'amir hasan','[email protected]','0587238390',26,'SA2652758389421292752626',50)
into user_ values (42,'ziyad mazen','[email protected]','0586243368',20,'SA3988376538681272406424',428)
into user_ values (43,'naif amjad','[email protected]','0544586012',20,'SA5957564399987414588979',77)
into user_ values (44,'jssar amir','[email protected]','0556071865',15,'SA2081715876825826506446',108)
into user_ values (45,'anmar ziyad','[email protected]','0560600776',25,'SA4166411197105892259441',491)
into user_ values (46,'ahmad ahmad','[email protected]','0536655633',28,'SA1395034898186149649848',208)
into user_ values (47,'amjad ammar','[email protected]','0545555544',22,'SA5922413433408583256419',158)
into user_ values (48,'alaa fisal','[email protected]','0564306636',24,'SA6913481934840933631226',256)
into user_ values (49,'amjad fisal','[email protected]','0559818413',27,'SA2422394342415922989769',92)
into user_ values (50,'hasan jasim','[email protected]','0555266071',18,'SA0216258718057435548174',68)
select * from dual


INSERT ALL
into courts values (2,'Al-Tahadi','M','football',111,'makkah')
into courts values (3,'Al-Raiah','L','football',148,'makkah')
into courts values (4,'Santarah','S','vollyball',141,'riyadh')
into courts values (5,'Koorah','M','vollyball',124,'taif')
into courts values (6,'Al-Ahli','M','vollyball',120,'makkah')
into courts values (7,'Al-Ruabi','L','basketball',154,'taif')
into courts values (8,'Al-khameis','S','vollyball',129,'madinah')
into courts values (9,'Al-Areda','L','football',113,'makkah')
into courts values (10,'Al-Shabab','M','basketball',124,'riyadh')
into courts values (11,'Al-Ejazah','L','basketball',143,'makkah')
into courts values (12,'Al-Zaher','L','football',144,'jeddah')
into courts values (13,'Al-Mojahdein','M','basketball',101,'taif')
into courts values (14,'Al-Sharaei','S','football',141,'madinah')
into courts values (15,'Al-Awali','L','vollyball',127,'makkah')
into courts values (16,'Rokni','M','basketball',124,'makkah')
into courts values (17,'Shababiat','L','vollyball',146,'madinah')
into courts values (18,'Makkah','L','football',101,'madinah')
into courts values (19,'Al-Safira','S','football',125,'madinah')
into courts values (20,'Al-Qadiseiah','S','vollyball',148,'madinah')
into courts values (21,'Al-Nassar','M','vollyball',104,'jeddah')
into courts values (22,'Al-Hassani','S','basketball',132,'makkah')
into courts values (23,'Al-Zawia','M','vollyball',117,'makkah')
into courts values (24,'Al-Rian','L','football',117,'makkah')
into courts values (25,'Al-Ain','M','football',158,'riyadh')
into courts values (26,'Hadramoot','S','football',124,'riyadh')
into courts values (27,'Al-Moghamas','L','basketball',132,'jeddah')
into courts values (28,'King','S','football',102,'taif')
into courts values (29,'Abdullah','S','basketball',150,'taif')
into courts values (30,'Al-Baladiah','L','basketball',159,'madinah')
into courts values (31,'Al-Malawi','S','basketball',107,'taif')
into courts values (32,'Al-Bahar','L','vollyball',116,'jeddah')
into courts values (33,'Al-Hilal','M','basketball',166,'taif')
into courts values (34,'Al-Jamoum','S','football',148,'madinah')
into courts values (35,'Al-Farouq','L','vollyball',130,'taif')
into courts values (36,'Zamaan','S','football',162,'madinah')
into courts values (37,'Umm','S','football',121,'makkah')
into courts values (38,'Alqura','M','basketball',110,'riyadh')
into courts values (39,'Al-Wehda','S','football',129,'madinah')
into courts values (40,'Al-Etifaq','M','vollyball',137,'makkah')
into courts values (41,'Al-Zohoor','L','vollyball',137,'jeddah')
into courts values (42,'Al-Salam','M','basketball',164,'madinah')
select * from dual

insert all
into res values (2,11, TO_DATE('021119', 'DD/MM/YY') ,'21')
into res values (10,32, TO_DATE('03419', 'DD/MM/YY') ,'04')
into res values (4,1, TO_DATE('22419', 'DD/MM/YY') ,'13')
into res values (20,27, TO_DATE('18919', 'DD/MM/YY') ,'16')
into res values (18,40, TO_DATE('23419', 'DD/MM/YY') ,'22')
into res values (46,29, TO_DATE('17919', 'DD/MM/YY') ,'13')
into res values (35,3, TO_DATE('09519', 'DD/MM/YY') ,'10')
into res values (40,4, TO_DATE('181119', 'DD/MM/YY') ,'24')
into res values (22,6, TO_DATE('15619', 'DD/MM/YY') ,'20')
into res values (8,20, TO_DATE('241219', 'DD/MM/YY') ,'18')
into res values (1,36, TO_DATE('01619', 'DD/MM/YY') ,'22')
into res values (31,17, TO_DATE('18419', 'DD/MM/YY') ,'01')
into res values (9,14, TO_DATE('16419', 'DD/MM/YY') ,'11')
into res values (4,12, TO_DATE('24219', 'DD/MM/YY') ,'13')
into res values (41,9, TO_DATE('161119', 'DD/MM/YY') ,'03')
into res values (4,35, TO_DATE('18819', 'DD/MM/YY') ,'22')
into res values (16,26, TO_DATE('031219', 'DD/MM/YY') ,'12')
into res values (14,2, TO_DATE('01219', 'DD/MM/YY') ,'08')
into res values (6,29, TO_DATE('061019', 'DD/MM/YY') ,'14')
into res values (20,23, TO_DATE('01219', 'DD/MM/YY') ,'10')
into res values (4,39, TO_DATE('041019', 'DD/MM/YY') ,'17')
into res values (13,31, TO_DATE('07519', 'DD/MM/YY') ,'12')
into res values (25,32, TO_DATE('061019', 'DD/MM/YY') ,'14')
into res values (5,42, TO_DATE('071119', 'DD/MM/YY') ,'15')
into res values (24,35, TO_DATE('061119', 'DD/MM/YY') ,'02')
into res values (36,30, TO_DATE('04919', 'DD/MM/YY') ,'21')
into res values (27,14, TO_DATE('231119', 'DD/MM/YY') ,'03')
into res values (18,8, TO_DATE('131219', 'DD/MM/YY') ,'14')
into res values (44,33, TO_DATE('04419', 'DD/MM/YY') ,'14')
into res values (35,42, TO_DATE('11919', 'DD/MM/YY') ,'01')
into res values (3,22, TO_DATE('14919', 'DD/MM/YY') ,'05')
into res values (26,23, TO_DATE('07919', 'DD/MM/YY') ,'09')
into res values (48,13, TO_DATE('25219', 'DD/MM/YY') ,'24')
into res values (38,29, TO_DATE('21819', 'DD/MM/YY') ,'17')
into res values (49,19, TO_DATE('14119', 'DD/MM/YY') ,'14')
into res values (20,29, TO_DATE('26819', 'DD/MM/YY') ,'10')
into res values (5,30, TO_DATE('02219', 'DD/MM/YY') ,'04')
into res values (35,12, TO_DATE('16819', 'DD/MM/YY') ,'06')
into res values (34,10, TO_DATE('19919', 'DD/MM/YY') ,'19')
into res values (15,33, TO_DATE('051119', 'DD/MM/YY') ,'16')
into res values (24,26, TO_DATE('18819', 'DD/MM/YY') ,'09')
into res values (15,3, TO_DATE('25519', 'DD/MM/YY') ,'17')
into res values (16,20, TO_DATE('25119', 'DD/MM/YY') ,'08')
into res values (17,10, TO_DATE('091119', 'DD/MM/YY') ,'14')
into res values (27,12, TO_DATE('20919', 'DD/MM/YY') ,'03')
into res values (35,21, TO_DATE('17719', 'DD/MM/YY') ,'19')
into res values (37,14, TO_DATE('26919', 'DD/MM/YY') ,'17')
into res values (24,33, TO_DATE('13419', 'DD/MM/YY') ,'23')
into res values (1,8, TO_DATE('09519', 'DD/MM/YY') ,'22')
into res values (15,3, TO_DATE('17419', 'DD/MM/YY') ,'07')
into res values (15,3, TO_DATE('141119', 'DD/MM/YY') ,'24')
into res values (20,1, TO_DATE('01419', 'DD/MM/YY') ,'08')
into res values (35,15, TO_DATE('26619', 'DD/MM/YY') ,'14')
into res values (14,30, TO_DATE('06819', 'DD/MM/YY') ,'16')
into res values (39,4, TO_DATE('19919', 'DD/MM/YY') ,'22')
into res values (28,15, TO_DATE('101219', 'DD/MM/YY') ,'09')
into res values (45,15, TO_DATE('24119', 'DD/MM/YY') ,'03')
into res values (7,3, TO_DATE('03919', 'DD/MM/YY') ,'07')
into res values (28,3, TO_DATE('09319', 'DD/MM/YY') ,'10')
into res values (41,1, TO_DATE('17819', 'DD/MM/YY') ,'13')
into res values (23,22, TO_DATE('04219', 'DD/MM/YY') ,'22')
into res values (18,6, TO_DATE('09419', 'DD/MM/YY') ,'13')
into res values (25,41, TO_DATE('03219', 'DD/MM/YY') ,'22')
into res values (50,12, TO_DATE('15419', 'DD/MM/YY') ,'23')
into res values (31,1, TO_DATE('05919', 'DD/MM/YY') ,'05')
into res values (39,36, TO_DATE('12719', 'DD/MM/YY') ,'01')
into res values (23,15, TO_DATE('04819', 'DD/MM/YY') ,'19')
into res values (43,39, TO_DATE('08119', 'DD/MM/YY') ,'11')
into res values (23,5, TO_DATE('19519', 'DD/MM/YY') ,'11')
into res values (21,12, TO_DATE('20819', 'DD/MM/YY') ,'09')
into res values (12,39, TO_DATE('011019', 'DD/MM/YY') ,'13')
into res values (28,26, TO_DATE('01819', 'DD/MM/YY') ,'03')
into res values (48,20, TO_DATE('041219', 'DD/MM/YY') ,'04')
into res values (25,21, TO_DATE('25419', 'DD/MM/YY') ,'14')
into res values (18,22, TO_DATE('171019', 'DD/MM/YY') ,'09')
into res values (46,41, TO_DATE('13619', 'DD/MM/YY') ,'01')
into res values (27,31, TO_DATE('111119', 'DD/MM/YY') ,'09')
into res values (48,23, TO_DATE('13919', 'DD/MM/YY') ,'02')
into res values (28,16, TO_DATE('15219', 'DD/MM/YY') ,'11')
into res values (11,22, TO_DATE('091219', 'DD/MM/YY') ,'20')
into res values (18,15, TO_DATE('081119', 'DD/MM/YY') ,'10')
into res values (28,8, TO_DATE('171119', 'DD/MM/YY') ,'07')
into res values (7,27, TO_DATE('01919', 'DD/MM/YY') ,'17')
into res values (39,2, TO_DATE('25519', 'DD/MM/YY') ,'07')
into res values (25,3, TO_DATE('20619', 'DD/MM/YY') ,'01')
into res values (39,15, TO_DATE('11819', 'DD/MM/YY') ,'06')
into res values (36,32, TO_DATE('21119', 'DD/MM/YY') ,'06')
into res values (7,10, TO_DATE('02719', 'DD/MM/YY') ,'15')
into res values (5,24, TO_DATE('15719', 'DD/MM/YY') ,'17')
into res values (9,32, TO_DATE('10219', 'DD/MM/YY') ,'22')
into res values (6,40, TO_DATE('20219', 'DD/MM/YY') ,'05')
into res values (37,16, TO_DATE('09619', 'DD/MM/YY') ,'11')
into res values (27,29, TO_DATE('14719', 'DD/MM/YY') ,'05')
into res values (7,2, TO_DATE('18519', 'DD/MM/YY') ,'18')
into res values (25,1, TO_DATE('06619', 'DD/MM/YY') ,'21')
into res values (9,15, TO_DATE('03919', 'DD/MM/YY') ,'07')
into res values (45,6, TO_DATE('14719', 'DD/MM/YY') ,'16')
into res values (10,39, TO_DATE('10519', 'DD/MM/YY') ,'12')
into res values (1,16, TO_DATE('03319', 'DD/MM/YY') ,'22')
into res values (1,37, TO_DATE('13319', 'DD/MM/YY') ,'16')
into res values (47,20, TO_DATE('06819', 'DD/MM/YY') ,'01')
into res values (17,21, TO_DATE('071219', 'DD/MM/YY') ,'01')
into res values (18,29, TO_DATE('06919', 'DD/MM/YY') ,'17')
into res values (47,19, TO_DATE('07419', 'DD/MM/YY') ,'24')
into res values (22,5, TO_DATE('02919', 'DD/MM/YY') ,'05')
into res values (36,38, TO_DATE('04919', 'DD/MM/YY') ,'20')
into res values (23,38, TO_DATE('181219', 'DD/MM/YY') ,'24')
into res values (20,40, TO_DATE('10419', 'DD/MM/YY') ,'09')
into res values (34,30, TO_DATE('03419', 'DD/MM/YY') ,'05')
into res values (44,18, TO_DATE('111019', 'DD/MM/YY') ,'19')
into res values (27,22, TO_DATE('231119', 'DD/MM/YY') ,'21')
into res values (30,11, TO_DATE('23919', 'DD/MM/YY') ,'04')
into res values (3,34, TO_DATE('26919', 'DD/MM/YY') ,'02')
into res values (24,14, TO_DATE('07119', 'DD/MM/YY') ,'07')
into res values (42,40, TO_DATE('24719', 'DD/MM/YY') ,'21')
into res values (1,7, TO_DATE('12819', 'DD/MM/YY') ,'12')
into res values (32,35, TO_DATE('07619', 'DD/MM/YY') ,'10')
into res values (20,40, TO_DATE('01919', 'DD/MM/YY') ,'05')
into res values (11,5, TO_DATE('06819', 'DD/MM/YY') ,'15')
into res values (49,25, TO_DATE('10219', 'DD/MM/YY') ,'07')
into res values (6,29, TO_DATE('22319', 'DD/MM/YY') ,'06')
into res values (22,11, TO_DATE('25519', 'DD/MM/YY') ,'05')
into res values (27,36, TO_DATE('18519', 'DD/MM/YY') ,'16')
into res values (10,3, TO_DATE('06219', 'DD/MM/YY') ,'24')
into res values (38,20, TO_DATE('18819', 'DD/MM/YY') ,'20')
into res values (26,11, TO_DATE('04619', 'DD/MM/YY') ,'23')
into res values (12,24, TO_DATE('07619', 'DD/MM/YY') ,'19')
into res values (48,21, TO_DATE('051119', 'DD/MM/YY') ,'19')
into res values (30,28, TO_DATE('041019', 'DD/MM/YY') ,'17')
into res values (47,27, TO_DATE('07719', 'DD/MM/YY') ,'12')
into res values (33,9, TO_DATE('10919', 'DD/MM/YY') ,'15')
into res values (48,34, TO_DATE('20819', 'DD/MM/YY') ,'04')
into res values (28,29, TO_DATE('05519', 'DD/MM/YY') ,'05')
into res values (46,32, TO_DATE('04819', 'DD/MM/YY') ,'20')
into res values (18,32, TO_DATE('20319', 'DD/MM/YY') ,'20')
into res values (13,4, TO_DATE('21619', 'DD/MM/YY') ,'03')
into res values (21,29, TO_DATE('03519', 'DD/MM/YY') ,'12')
into res values (43,37, TO_DATE('08419', 'DD/MM/YY') ,'21')
into res values (6,31, TO_DATE('19919', 'DD/MM/YY') ,'03')
into res values (8,24, TO_DATE('13219', 'DD/MM/YY') ,'03')
into res values (20,30, TO_DATE('101019', 'DD/MM/YY') ,'18')
into res values (7,8, TO_DATE('171019', 'DD/MM/YY') ,'21')
into res values (2,1, TO_DATE('13819', 'DD/MM/YY') ,'18')
into res values (22,2, TO_DATE('181119', 'DD/MM/YY') ,'21')
into res values (3,6, TO_DATE('17819', 'DD/MM/YY') ,'20')
into res values (25,35, TO_DATE('12419', 'DD/MM/YY') ,'03')
into res values (30,1, TO_DATE('18919', 'DD/MM/YY') ,'18')
into res values (19,29, TO_DATE('201019', 'DD/MM/YY') ,'01')
into res values (22,13, TO_DATE('03619', 'DD/MM/YY') ,'14')
into res values (40,13, TO_DATE('13219', 'DD/MM/YY') ,'09')
into res values (37,1, TO_DATE('161119', 'DD/MM/YY') ,'23')
select * from dual