Notes

--create database veritabani
use veritabani
--create table musteri (
--m_no int primary key identity (1,1),
--ad varchar(30),
--soyad varchar (30),
--tel int ,
--email varchar(30),
--adres varchar(30),
--sehir varchar (30)
--)
--create table siparis_detay(
--d_no int primary key identity (1,1),
--s_no int,
--u_no int,
--miktar int
--)

--insert into musteri values
--('Kemal','Kaya',1111111,'[email protected]','bornova','izmir'),
--('mehmet','Çetin',2222222,'[email protected]','egekent','izmir'),
--('ceyda','duran',3333333,'[email protected]','pendik','istanbul'),
--('serdar','çolak',4444444,'[email protected]','ulus','ankara'),
--('derya','sönmez',5555555,'[email protected]','bakırköy','istanbul'),
--('ayşe','ölmez',66666666,'[email protected]','avcılar','istanbul'),
--('ibrahim','duran',77777777,'[email protected]','konak','izmir'),
--('selma','yavuz',88888888,'[email protected]','alsancak','izmir'),
--('burak','tan',99999999,'[email protected]','çankaya','ankara'),
--('kenan','yıldız',1010101,'[email protected]','yenimahalle','bursa'),
--('leyla','turan',1101101,'[email protected]','bandırma','balıkesir'),
--('güneş','burcu',1212121,'[email protected]','marmaris','muğla'),
--('petek','başak',1313131,'[email protected]','esenler','istanbul')


--insert into siparis_detay values
--(1,2,1),
--(1,20,1),
--(2,9,1),
--(3,11,4),
--(4,16,5),
--(4,29,1),
--(5,19,1),
--(6,12,1),
--(6,18,2),
--(7,7,1)

--create table kategori (
--k_no int primary key identity (1,1),
--ad varchar (30)
--)

--insert into kategori values
--('Bilgisayar'),
--('Laptop'),
--('Televizyon'),
--('Cep Telefonu'),
--('Kitap'),
--('CD')


--create table siparis(
--s_no int primary key identity (1,1),
--m_no int,
--tarih date,
--t_fiyat int
--)


--insert into siparis values
--(3,'2010/01/01',924),
--(7,'2010/01/03',2200),
--(7,'2010/03/01',3000),
--(1,'2010/04/01',2740),
--(12,'2010/01/04',350),
--(5,'2010/01/04',1800),
--(8,'2010/05/01',1400)


--create table urun (
--u_no int primary key identity (1,1),
--ad varchar (30),
--k_no int,
--fiyat int,
--stok int
--)


--insert into urun values
--('Casper pc',1,800,12),
--('IBM pc',1,900,14),
--('HP pc',1,1200,0),
--('Toshiba pc',1,1600,9),
--('Exper pc',1,1250,10),
--('Sony Laptop',2,2100,5),
--('HP Laptop',2,1400,7),
--('Toshiba Laptop',2,1600,0),
--('Vestel plazma tv',3,2200,4),
--('Samsung tv',3,800,13),
--('Philips Tv',3,750,5),
--('Sony tv',3,900,16),
--('Samsung plazma tv',3,3400,0),
--('LG plazmaTv',3,5600,5),
--('Nokia series',4,500,14),
--('Samsung series',4,600,6),
--('Sony Ericsoon Series',4,450,22),
--('Siemens series',4,350,13)


--select * from musteri inner join siparis on musteri.m_no=siparis.m_no
--select * from musteri inner join siparis on musteri.m_no=siparis.m_no where musteri.sehir!='izmir'
--select musteri.m_no,musteri.ad,musteri.soyad,siparis.s_no,siparis.tarih from musteri inner join siparis on musteri.m_no=siparis.m_no
--select * from musteri where soyad='duran'
--select * from siparis where t_fiyat>=2000
--select * from siparis where tarih between '2010/01/01'and'2010/01/03'
--select * from musteri where adres is not null
--select COUNT(u_no) from urun
--select AVG(DISTINCT fiyat) from urun
--select SUM(fiyat) from urun where stok>10
--select avg(urun.fiyat) from urun where urun.k_no=4
--select MAX(urun.fiyat) from urun where urun.k_no=3
--select COUNT(sehir) from musteri group by(sehir)
--select COUNT(DISTINCT sehir) from musteri