CREATE TABLE personel
(
isim CHAR(20),
soyad VARCHAR(12),
il CHAR(20),
cins CHAR(2),
yas  TINYINT,
sinif  INTEGER,
boy DECIMAL(6,2),
puan INTEGER
 );
 
 

 INSERT INTO personel VALUES
 ('Efe','Akar','Adana','E',20,1,186.45,99),
 ('Emine','Naz','Maras','K',17,3,150.01,42),
 ('Enes','Simsek','Adana','E',21,2,162.01,78),
 ('Ali','Ay','Aksaray','E',19,1,185.68,10),
 ('Eyyüp','Yildirim','Malatya','E',19,2,185.00,65),
 ('Mehmet','Demir','Adana','E',19,3,180,31),
 ('Nurettin','Durar','Aksaray','E',19,2,191,65),
 ('Emre','Özdemir','Kırıkkale','E',18,2,185,12),
 ('Ahmet','Ünlü','Konya','E',19,1,190.48,50),
 ('Sultan','Yıldız','Nevşehir','K',19,2,165.25,90),
 ('Faruk','Ay','Aksaray','E',44,2,194.54,100),
 ('Aydın','Özdemir','Kırıkkale','E',47,1,178.49,10),
 ('Osman','Akar','Adana','E',44,2,182.54,100),
 ('Kemal','Simsek','Adana','E',50,3,178.45,45),
 ('Osman','Gultekin','Ardahan','E',28,1,175.67,10),
 ('Alpercan','Gur','Nigde','E',20,2,181.63,30),
 ('Mustafa','Kaya','Adana','E',18,2,186.27,80),
 ('İlayda','Demir','Konya','K',19,1,159.68,70),
 ('Sude','Oztas','Ankara','K',18,2,156.17,10),
 ('İrem','Basbatan','Ankara','K',19,1,168.14,20),
 ('Fatma','Uluturk','Aksaray','K',18,2,135.28,40),
 ('Hasan','Arıbas','Aksaray','E',19,3,182.15,60),
 ('Muhammed','Celik','Mersin','E',19,1,180.00,50),
 ('Samet','Yildiz','Aksaray','E',19,2,170.24,75),
 ('Ertuğrul','Azizoglu','Hatay','E',21,2,168.30,74),
 ('Selda','Yazici','Aksaray','E',18,1,158.23,56),
 ('Halil','Yildizdas','Sanliurfa','E',20,2,168.23,55),
 ('Mert','İvan','Iraq','E',19,2,176.23,65),
 ('Elif','Songur','Ankara','K',19,1,152,32);