vsizov · November 29, 2013 14:44
diff --git a/gistfile1.sql b/gistfile1.sql
 select f.*, count(*) cnt 
 from feedbacks f 
 LEFT JOIN feedbacks fn ON fn.id = (SELECT MAX(id) FROM feedbacks WHERE customer_id = f.customer_id)
 WHERE (f.comment IS NOT NULL OR f.testimonial IS NOT NULL) AND f.company_id = 42
 GROUP BY f.recommend;
	select f., count() cnt
	from feedbacks f
	LEFT JOIN feedbacks fn ON fn.id = (SELECT MAX(id) FROM feedbacks WHERE customer_id = f.customer_id)
	WHERE (f.comment IS NOT NULL OR f.testimonial IS NOT NULL) AND f.company_id = 42
	GROUP BY f.recommend;