use okul
select * from ogrenci
select * from bolum
insert into bolum values ('Elektrik Mühendisliği')
select * from bolum where bolum.BAdi LIKE 'B%'
select * from bolum where bolum.BAdi LIKE 'E%' or BAdi LIKE '%İ%'  --son harfi i olan
select * from ogrenci where ONo IN (1,2,5,20)
select * from ogrenci where OAdi LIKE ('__İ') --3. harfi i olan

Create database Galeri
use Galeri
Create table Musteri(
MNo int primary key identity(1,1),
MAd varchar(50) NOT NULL,
MSoyadi varchar(100) NOT NULL,
MAdres varchar(250) NULL DEFAULT('Bilecik'),
MTel varchar(15)
)
Create table Arac(
ANo int primary key identity(1,1),
Model int CHECK(Model>=1900 and Model<=9999),
Marka varchar(200),
Plaka varchar(20) NOT NULL,
Afiyat money
)
Create table Satis(
SNo int primary key identity(1,1),
MNo int foreign key References Musteri(MNo),
ANo int foreign key References Arac(ANo),
STrh datetime,
Sfiyat money
)
Create table Alim(
AlNo int primary key identity(1,1),
MNo int foreign key References Musteri(MNo),
ANo int foreign key References Arac(ANo),
ATrh datetime,
Afiyat money
)

select * from Musteri
insert into Musteri values ('Cetin','Mert','Eskisehir',14565)
insert into Musteri values ('Umut','Metin','Ankara',35435)
insert into Musteri values ('Ufuk','Gül','Ankara',35435)



select * from Arac
select * from Arac where Afiyat between 30000 and 80000
select * from Arac where Plaka LIKE '11%'
select * from Arac order by Afiyat desc              --fiyat en yüksekten en düşüğe sırala
select distinct Musteri.MAdres from Musteri   -- Ankara 1 kere gelsin distinct**
select * from Arac where Plaka LIKE '11%' order by ANo desc

select MAd AS 'Musteri Adi:', MSoyadi AS 'Musteri Soyadi:' from Musteri

select * from Musteri order by MAd asc
select * from Arac order by Model, Afiyat desc
select Satis.ANo,Satis.Sfiyat,Satis.STrh from Satis
select Arac.ANo,Satis.Sfiyat,Satis.STrh from Satis INNER JOIN Arac ON Satis.SNO=Arac.ANo
select * from Arac where Afiyat>=12000 order by Afiyat desc
select * from Satis where Sfiyat>=10000 or MNo=4
select * from Satis where STrh>=1/4/2010
select * from Alim where Afiyat>=10000 and ATrh between 2/1/2010 and 6/1/2010
select * from Arac where Afiyat between 10000 and 20000