SELECT
	musteriler.musteriAd,
    COUNT(urunler.urunMusteriID) AS UrunAdet,
    MIN(urunTarihi) AS SonUrun
FROM urunler
INNER JOIN musteriler ON urunler.urunMusteriID = musteriler.musteriID
WHERE musteriler.musteriIsletmeID = '1'
AND urunler.urunPasif != '1'
GROUP BY musteriAd
ORDER BY SonUrun ASC;