SQL BETWEEN-AND KALIBI

--------BETWEEN-AND KALIBI-----------
--Belirli bir deger araligindaki verilerin listelenmesi icin kullandıgımız anahtar kelimedir
--Stok miktarı 20'den buyuk 49'den kucuk urunleri listeleyiniz...
Select ProductName,UnitPrice,UnitsInStock from Products where UnitsInStock between 20 and 49
order by UnitsInStock
--01.01.1997 ile 06.06.1998 tarihleri arasindaki siparisleri listeleyiniz..
Select OrderID,OrderDate from Orders where OrderDate between '01.01.1997' and '06.06.1998'
order by OrderDate desc
--Bas harfi C olan stoklarda mevcut,10-250 dolar arasi ucreti olan urunleri fiyatlarina göre listeleyiniz..
Select ProductName,UnitPrice,UNitsInStock from Products where UnitPrice between 10 and 250
and LEFT(ProductName,1)='c'
and UnitsINStock>0
order by UnitPrice
--Carsamba gunu alinan,kargo ucreti 20-75 arasinda olan,teslim tarihi null
--olmayan siparislerin bilgilerini raporlayınız ve OrderID'sine gore buyukten kucuge siralayınız..
Select OrderId,Freight,ShippedDate,Orderdate from Orders where Freight between 20 and 75
and DATENAME(weekday,OrderDate)='Wednesday'
and ShippedDate is not null
order by OrderID desc