CREATE TABLE Birey(
 ID int NOT NULL,
 TcNo varchar(11) NOT NULL,
 Adi varchar (50) NULL,
 Soyadi varchar (50) NULL,
 AnneAdi varchar (50) NULL);


ALTER TABLE birey ADD dogumyeri varchar(50);

INSERT INTO birey VALUES 
(2, 12345678902, "Hakan", "KÖR", "Emine", "İskilip");
INSERT INTO birey VALUES 
(3, 12345678902, "Ayşe", "YILMAZ", "Esra", "İskilip");
INSERT INTO birey VALUES 
(4, 12345678902, "Pınar", "Öztürk", "Fatma", "İskilip");
INSERT INTO birey VALUES 
(5, 12345678902, "Mustafa", "KÖR", "Zeynep", "İskilip");


SELECT Adi,Soyadi,dogumyeri FROM birey where AnneAdi="Fatma"