SELECT
DATE_FORMAT(tarih,'%d-%m-%Y') AS tarih,
count(*) as kullanilan_oy,
COUNT(CASE WHEN memnuniyet_durumu = 1 THEN 1 END) as begenen,
COUNT(CASE WHEN memnuniyet_durumu = 2 THEN 1 END) as iyilestirmeli
FROM yemekhane_anket
GROUP BY DATE(tarih);