SELECT * 
FROM tablo_adı 
WHERE AD = 'Yunus'
  AND SOYAD LIKE 'G%'
  AND DOGUMTARIHI BETWEEN '2009-01-01' AND '2009-12-31';