Notes

create table musteri(musteri_id int primary key, musteri_ad varchar(400), musteri_soyad varchar(400),musteri_adres varchar(40));
insert into musteri values(1,"Mehmet","Kaplan","Adıyaman/Merkez/Altınşehir Mah.");
insert into musteri values(2,"Ahmet","Çelik","Adıyaman/Merkez/Altınşehir Mah.");
insert into musteri values(3,"Furkan","Demir","Adıyaman/Merkez/Altınşehir Mah.");
insert into musteri values(4,"Ömer","Aslan","Adıyaman/Merkez/Altınşehir Mah.");
insert into musteri values(5,"Emir","Özdemir","Adıyaman/Merkez/Altınşehir Mah.");
create table urun(urun_id int primary key, urun_ad varchar(400), alis_fiyat int, satis_fiyat int, alis_tarihi int, stok int );
insert into urun values(1,"Su 0,5L",0.25,2,2022,2000);
insert into urun values(2,"Ayran 330ML",3,5,2022,2000);
insert into urun values(3,"Kola 2.5L",7,25,2022,2000);
insert into urun values(4,"Ekmek",3,5,2022,2000);
insert into urun values(5,"Süt 1L",6,10,2022,2000);
insert into urun values(6,"Iphone 14 PRO 1TB",47000,55000,2022,200);
create table fatura(fatura_id int primary key,urun_id int, musteri_id int, urun_ad varchar(400),adet int);
insert into fatura values(1,6,1,"Iphone 14 PRO 1TB",1);
insert into fatura values(2,5,2,"Süt",2);
insert into fatura values(3,6,3,"Iphone 14 PRO 1TB",1);
insert into fatura values(4,2,4,"Ekmek",4);
insert into fatura values(5,3,5,"Kola",1);
select musteri.musteri_ad,musteri_soyad,fatura.urun_ad,adet from fatura,musteri where fatura.musteri_id = musteri.musteri_id;