@MaxidaTa; 
SELECT SUM(`miktar`) AS `toplam` FROM `test` WHERE YEAR(`tarih`) = YEAR(CURDATE()) AND MONTH(`tarih`) = MONTH(CURDATE())
@edit: @mtn; tam ben yazıyordum ya